Discussion Locked
Excel If Formual
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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"