"Planko" wrote:
I am using:
=F45/F45+G45

Works and I get the info I want except if F45 or G45 total 0.
Then I get the DIV error. I need it to say "n/a" if the total
is zero.

You only get a #DIV/0 error if F45 is zero.

So ostensibly, you could write:

=IF(F45=0,"n/a",F45/F45+G45)

But F45/F45 nonsensicle: it is always 1 except when F45 is zero. (And you
are free to define 0/0 as 1 if that is your intention.)

Moreover, you said you want "n/a" if the "total is zero". What total:
1+G45?

And you said the original works except if "F45 __or__ G45 __total__ 0".
That's meaningless. Do you mean: if F45 or G45 is zero? Or do you mean:
if 1+G45 is zero?

Perhaps the following meets your needs:

=IF(OR(F45=0,G45=0),"n/a",1+G45)