Help...

I am trying to write a formula that looks at B3 and if it's 0 to leave it that way but if B3's value is greater than or equal to 900 or C3's value is greater than or equal to 175 to enter STOP but if not then enter OK. But I also want it to see is B3's value falls between 800 and 899 or C3's value falls between 100 and 174 to enter CAUTION if true but if not "".

Any ideas.

=IF($B3=0," ",IF(OR($B3>=900,$C3>=175),"STOP","OK")) This one works for the STOP portion but I tried adding the extra criteria to indicate caution or OK or "" and nothing works

This is what I tried
=IF($B3=0," ",IF(OR($B3>=900,$C3>=175),"STOP","OK")(IF($B3=MEDIAN(800:899),"CAUTION","")))

and

=IF($B3=0," ",IF(OR($B3=MEDIAN(800:899)),"CAUTION",("$B3>=900,$C3>=175),"STOP","OK")

nothing works