Forum Discussion
Solved
Formula help: Formula must show any number <50 as 50 and if it is >100 as 100
Hi! I need a bit of help with this formula that I am trying to setup for a class test result sheet: I have tried this formula but it keeps saying #VALUE? =IF(SUM(E8)<50,50,SUM(E8))&=IF(SUM(...
This should work for you:
=MIN(100,MAX(E8,50))
Just so you can see the IF statement working though this is what it would look like:
=IF(E8<50,50,IF(E8>100,100,E8))
It works something like this.. if E8 is smaller then 50, the answer is 50, else if E8 is larger than 100, the answer is 100, else the answer is E8.
Hope that helps.
:) no problem. Glad it helped.