iferror
Your error will only ever occur if F5=0, so you could use the nested IF like
this:
=IF(G5/51,F5/G5,IF(F5=0,"ERROR",G5/F5))
You can replace the "ERROR" to "" or whatever other value you want to display.
This also assumes that F5 and G5 are populated with numbers.
--
John C
"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
|