General discussion

Locked

Excel If Formual

By LF King ·
Have the following formula
=IF(B8>8,"Yes",IF(B8<8,"No",IF(C8>10,"Yes",IF(C8<10,"No"))))

The formula works fine, but how can I have it look at the cell when it is empty, return string of text to remind the user to enter a number.
Example If blank,"Enter Rate Spread"

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums