| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement help
I am trying to forecast revenue using an if statement. I'm trying to take a
date and result with a number from another cell. I have a projected revenue date in B13 formatted as mmm-yy (Jun-08) A revenue number is located in C13 (1000) I write this formula =IF(B13="Jun-08",C13,0) My result is always 0 and I want 1000. Any suggestions? BTW - I'm not a pro in excel so I might need a thorough explaination. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| IF and AND statement | Excel Worksheet Functions | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Threaded Mode
