thanks for replies
but am still having probs showing 0 rather than DIV/0
--
thanks
Roy


"Lars-Åke Aspelin" wrote:

On Wed, 30 Jul 2008 07:57:01 -0700, Roy Gudgeon
wrote:

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

Try this:

=IF(G55,F5/G5,IF(F5=0,0,G5/F5))

Hope this helps / Lars-Åke