Can I add more than 2 comparisons to an IF statement??

G

Guest

Hi can some one help me.
The user enters a number (percentage) in cell C8. There is Another Number in
D8.
My IF statement reads
=IF(C8>D8-2%,"EXCELLENT","NEEDS ADJUSTING")
This works fine.
THE PROBLEM is that even though Nothing has been entered in the Cell C8 yet
the I keep recieving the Message "EXCELLENT".
THE QUESTION if have is what syntax do I use to tell excel to first check if
C8 is BLANK, if it is, to also return a BLANK, if it is not THEN TO Follow
the IF STATEMENT, above.
 
D

Dave Peterson

=if(c8="","",if(c8>d8-2%, .....


Hi can some one help me.
The user enters a number (percentage) in cell C8. There is Another Number in
D8.
My IF statement reads
=IF(C8>D8-2%,"EXCELLENT","NEEDS ADJUSTING")
This works fine.
THE PROBLEM is that even though Nothing has been entered in the Cell C8 yet
the I keep recieving the Message "EXCELLENT".
THE QUESTION if have is what syntax do I use to tell excel to first check if
C8 is BLANK, if it is, to also return a BLANK, if it is not THEN TO Follow
the IF STATEMENT, above.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Calculations as Days 6
I need the cell to be blank instead of showing #DIV/0! 5
How do I get the IF function to work on more than one criterion? 5
easy if statement formula 2
... I want to print $0.00 if ... 2
how do I add round to a IF statement? 4
Excel Formula to add network file link to each month 1
MATCH/IF/OR/AND statements not what I need apparently 1

Top