Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Guys
I am currently using office 2007 I have a large spreadsheet that uses the following formula: =IF(G5/51,F5/g5,g5/f5) This produces a "div/0" error from time to time when the values in G5 & F5 are 0 I have been trying to use iferror to resolve this to report 0 but keep getting an error message suggesting either a problem with the formula or not enough arguments etc.... Any suggestions as to the correct formula ? thanks Roy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IFERROR in 2003 version | Excel Discussion (Misc queries) | |||
IFERROR in Excel 2007 | Excel Worksheet Functions | |||
How do I round up the answer an iferror formula? | Excel Discussion (Misc queries) | |||
IFERROR help | Excel Discussion (Misc queries) | |||
Time for IFERROR? | Excel Worksheet Functions |