Formulas

[paulc1232]

Hi there i currently have this formula

=IF(ISNUMBER(F5),IF(F5 > -0.8%, 4,IF(AND(F5 <= -0.8%, F5 <= -1%),0,2)),"")

this makes the box turn to 4,0,2 depending on it % but can anyone tell me how i can add to the formula so that if its a blank cell it puts a 4 aswell.

Thank you

 

[PhilW_34]

Hi Paul,

Is this what you are looking for? Just add another if command at the front of the other commands.

=IF(ISNUMBER(F5),IF(F5="",4,IF(F5 > -0.8%, 4,IF(AND(F5 <= -0.8%, F5 <= -1%),0,2))),"")

Phil