| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Help With IF statement
Hello,
Here's what I'm trying to do. I have a number in cell C2. If the number is 0 I want cell D2 to display, NEUTRAL, if the number in cell C2 is 0 I want cell D2 to display OVER, and if the number in cell C2 is <0 I want cell D2 to display UNDER. I hope that makes sense. Thanks for any help anyone can give. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need Help With IF statement
=IF(C2="","",IF(C20,"Over",IF(C2=0,"Neutral","Und er")))
-- Regards, Peo Sjoblom "XFILES" wrote in message ... Hello, Here's what I'm trying to do. I have a number in cell C2. If the number is 0 I want cell D2 to display, NEUTRAL, if the number in cell C2 is 0 I want cell D2 to display OVER, and if the number in cell C2 is <0 I want cell D2 to display UNDER. I hope that makes sense. Thanks for any help anyone can give. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need Help With IF statement
Nevermind. I figured it out.
"XFILES" wrote: Hello, Here's what I'm trying to do. I have a number in cell C2. If the number is 0 I want cell D2 to display, NEUTRAL, if the number in cell C2 is 0 I want cell D2 to display OVER, and if the number in cell C2 is <0 I want cell D2 to display UNDER. I hope that makes sense. Thanks for any help anyone can give. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need Help With IF statement
=IF(C2=0,"NEUTRAL",IF(C20,"OVER","UNDER"))
Regards, Paul "XFILES" wrote in message ... Hello, Here's what I'm trying to do. I have a number in cell C2. If the number is 0 I want cell D2 to display, NEUTRAL, if the number in cell C2 is 0 I want cell D2 to display OVER, and if the number in cell C2 is <0 I want cell D2 to display UNDER. I hope that makes sense. Thanks for any help anyone can give. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need Help With IF statement
Thanks for all the great answers. I appreciate it. You people are the best.
"PCLIVE" wrote: =IF(C2=0,"NEUTRAL",IF(C20,"OVER","UNDER")) Regards, Paul "XFILES" wrote in message ... Hello, Here's what I'm trying to do. I have a number in cell C2. If the number is 0 I want cell D2 to display, NEUTRAL, if the number in cell C2 is 0 I want cell D2 to display OVER, and if the number in cell C2 is <0 I want cell D2 to display UNDER. I hope that makes sense. Thanks for any help anyone can give. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need Help With IF statement
in D2 enter
=if(C20,"Over",If(C2<0,"Under",Neutral")) "XFILES" wrote: Hello, Here's what I'm trying to do. I have a number in cell C2. If the number is 0 I want cell D2 to display, NEUTRAL, if the number in cell C2 is 0 I want cell D2 to display OVER, and if the number in cell C2 is <0 I want cell D2 to display UNDER. I hope that makes sense. Thanks for any help anyone can give. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement help | Excel Discussion (Misc queries) | |||
| If statement help please | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Hybrid Mode
