Forum Discussion
Formula help: Formula must show any number <50 as 50 and if it is >100 as 100
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.
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.
MIN(MAX()) can be shortened to MEDIAN().
=MEDIAN(50;100;E8)
Thanks so much Detlef Lewin!
This has made my life so much easier! You are awesome!
You are so awesome! Thank you so much! I really appreciate your time helping me out.
Thank you so much!
