IFERROR

[ozbeachbum]

Hi,
I have the following formula which returns an error when divided by zero, I have tried numerous bracketing arrangements and searched the net high and low, but have not been able to solve the issue.
Any assistance would be greatly appreciated.
=(AG70-S70)/S70 Returns correct answer when divided by greater then zero.
I thought the following would be the solution when the formula is dividing by zero, however it returns (to few arguments).
=IFERROR(AG70-S70)/S70,0)
Cheers,
Dave.

 

[Alex Blakenburg]

You are one bracket short

=IFERROR( (AG70-S70)/S70, 0 )

 

[ozbeachbum]

Thanks Alex, really appreciated.

 

[Alex Blakenburg]

You're welcome. Glad I could help.