Thanks T Valko but it still returns the Div error.

Lars, John C, I want to report 0 when both g5 & f 5 are zero.
thanks for continued help
--

Roy


"T. Valko" wrote:

Try this:

=IF(G5/51,F5/G5,IFERROR(G5/F5,0))


--
Biff
Microsoft Excel MVP


"Roy Gudgeon" wrote in message
...
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