iferror
Actually, since the OP said he wanted a 0 instead of a DIV/0 error posted,
his formula works just fine.
--
John C
"Lars-Åke Aspelin" wrote:
Pedro, your formula does not fly.
F5*G5=0 is NOT the same as AND(F5=0,G5=0)
Check with F5=0 and G5=4
Lars-Åke
On Wed, 30 Jul 2008 17:12:29 +0200, Infinitogool
wrote:
Hi Roy
Try
=IF(F5*G5=0,"value 0",IF(G5/51,F5/G5,G5/F5))
Regards,
Pedro J.
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
|