Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I add more than 2 comparisons to an IF statement??
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(C8D8-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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
What statement to use? | Excel Worksheet Functions |