General discussion
January 15, 2004 at 12:20 PM
lf king

Excel If Formual

by lf king . Updated 22 years, 7 months ago

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 discussion is locked

All Comments