Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 36
Default iferror

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IFERROR in 2003 version Drew[_2_] Excel Discussion (Misc queries) 5 April 7th 14 01:01 PM
IFERROR in Excel 2007 Dirrk Excel Worksheet Functions 5 April 25th 10 10:08 PM
How do I round up the answer an iferror formula? stecole Excel Discussion (Misc queries) 1 July 8th 08 05:10 AM
IFERROR help Pete DeKalb Excel Discussion (Misc queries) 2 April 12th 08 03:42 AM
Time for IFERROR? PAL Excel Worksheet Functions 7 February 13th 08 09:52 AM


All times are GMT +1. The time now is 05:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"