worksheet function – Microsoft Excel 2003 Limit Value between two Values


I’m trying to get around writing a macro. I have a field with a function involving a small calculation. If the result is greater than 1, it should set the result to 1. If the result is smaller than 0, it should set the result to 0. Since I need a matrix for graph plotting I cannot use if statements.