Maybe I’m just using the wrong search terms both in google and the help file, but I can’t figure out how to do this in excel.
I need a way to limit cells between 0 and 35. In other words, if the value of a calculation falls below 0, then the value displayed by the cell is 0. At the same time, if the value of a calculation is above 35, then the value displayed by the cell needs to be 35.
Any idea how to do this? I’m working with a sizable spreadsheet and really don’t want to have to go through and manually change every negative number to 0 and every number greater than 35 to 35 every time new data is introduced.
Please help! The sooner I get this done, the sooner I get to go out and enjoy my Saturday!