| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I add more than 2 comparisons to an IF statement??
=if(c8="","",if(c8d8-2%, .....
joshua wrote: 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. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I add more than 2 comparisons to an IF statement??
Thank you Dave! Appreciate the help SOoooooMuch!
joshua "Dave Peterson" wrote: =if(c8="","",if(c8d8-2%, ..... joshua wrote: 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. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I add more than 2 comparisons to an IF statement??
=IF(and(isblank(c8)=false,C8D8-2%),"EXCELLENT","NEEDS ADJUSTING")
-- Don Guillett SalesAid Software "joshua" wrote in message ... 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. |
| Reply |
| 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 | |||
Hybrid Mode
