| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting rid of error messages while using IF statements
Hello,
I have a series of relatively simple formulas, set up in a complex manner that are returning errors on me. I have an assumptions sheet that the first formula makes reference to. Sometimes a cell in the assumptions will be blank, and sometimes it won't as the data changes. the first formula is: A10 =1/Assumptions!AB18 Now if the cell in Assumptions!AB18 happens to be blank, the next formula will return a #DIV/0 error: C10 =$A10*C$3 Finally, if there is a 0 or #DIV/0 in C10 then the formula in E10 will error out as well. E10 =IF(D10="",$A10*D$3,($A10-((D10/2)*$A10))*D$3) I realize this may be troublesome to get the mind around. But is there any way, in the last formula (E10) to tell it to do nothing if C10 is blank? And the same for C10, and then the same for A10? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
| How do I sum percentages calculated from IF statements? | Excel Worksheet Functions | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| Better Way to Code IF Statements? | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Worksheet Functions | |||
Threaded Mode
