| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with IF statement
In BA4 I have this: =IF(AX4=0,"",AX4-AQ4)-AU4 is giving me #VALUE! when all
cells are blank. If all cells have data, I get the right answer. AX and AQ columns are date format, whereas AU is number format. Is that my problem? Here's one that works, with BA being the answer: Col. AQ Col. AX Col. AU Col. BA 11/22/2006 12/5/2006 14 -1 Thank you Connie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I'm having a really strange problem with 3 if statements. | Excel Worksheet Functions | |||
| If Statement linked to cell with VLOOKUP problem - getting wrong v | Excel Worksheet Functions | |||
| Fundamental problem with IF statement | Excel Worksheet Functions | |||
| Formula Problem - If Statement | Excel Worksheet Functions | |||
| Excel Display Problem | Excel Discussion (Misc queries) | |||
Threaded Mode
