| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Statement
I am working with a spreadsheet that uses the conditional statement as follows:
=IF(C7=9999,0,(+B7-A7)*24). The forumla works fine when B7 and A7 have data in them, however when the formula references cells that don't contain any data I get a #value error. How can i get the same results from the formula and not get the error message. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional If Statement | Excel Discussion (Misc queries) | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Conditional If statement | Excel Worksheet Functions | |||
| conditional statement | New Users to Excel | |||
| Conditional if statement | Excel Worksheet Functions | |||
Threaded Mode
