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"