Check for both values before dividing..

=IF(B56=0,0,IF(B59=0,0,+B56/$B$59))

If this post helps click Yes
---------------
Jacob Skaria


"MO" wrote:

Hi.

I'm getting the above error because I have zeros in certain cells/rows that
cross foot percentages. I can't understand why the fix I used to have others
go to 0% won't work in two instances. =IF(+B56=0,0,+B56/$B$59) is an example
of the fix that works, but not all the time.

Can you help?
--
Thank you for your help
MO
Albany, NY