| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting rid of error messages while using IF statements
**********
You can generally get around this type of hurdle with an IF statement: for instance =IF(Assumptions!AB18=0,"",1/Assumptions!AB18) This returns a blank if AB18 equals zero, and performs the division if AB18 is not zero. Can you use that logic to flow through the various calculations in your sprdsht? *********** Unfortunately not. Having it display a blank is recognized by excel, which then in turn causes the other cells to display a #VALUE error. *********** Hi, You could use something like =IF(ISERROR(C10),"",$A10*D$3,($A10-((D10/2)*$A10))*D$3) This will give you a blank in case C10 is #DIV/0 Regards, Bondi ********** Much appreciated but unfortunately the formula does not work - too many arguements. |
| 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
