| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using ISERROR to Solve #DIV/0 in a formula
Hi
Apologies if i am repeating someone elses question, but can someone help me enter the ISERROR function into this formula to get rid of the #DIV/0 message? =IF(G43+C43=0,0,(G43/C43)) Basically cell C43 is a zero, so when the formula calculates the last section I am getting the #DIV/0 error. Can I add the ISERROR function to display a '0' instead or anything else for that matter? Thanks in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use Excel to solve inequality formula? | Excel Discussion (Misc queries) | |||
| formula to solve | Excel Discussion (Misc queries) | |||
| Formula to solve | Excel Discussion (Misc queries) | |||
| Int Iserror Len Mid Find formula | Excel Worksheet Functions | |||
| simple average formula...can you solve it in principle? | Excel Discussion (Misc queries) | |||
Threaded Mode
