To try to clarify further, the below formula is in preceeding rows which
provides a result of 0 as it should. The forumula that is in the cell where
I am getting the error is =+B89/B98--both of those cells have 0 in them.
--
Thank you for your help
MO
Albany, NY


"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