The formula you put in your original post (=F45/F45+G45) would also give you 200% and not 50%.....

I'm not sure I understand what you're trying to achieve with this.
Dividing the value in F45 by F45, as in the first part of your formula, will always give you 1 unless F45 contains zero to start with.

Perhaps if you could explain a little more about what you're trying to achieve it would be possible to get the right formula for you.

Ok, I am sorry.

Here is the formula I am using to get my percentage of two columns:

=F45/(F45+G45) <-----I missed one ( here when typing it. Sorry.

I get the right percentage of the total columns. If F45 = 1 and G45 = 0 I get 50%. That all works fine.

But some of the columns will not have numbers to calculate. If F45 and G45 total zero I get the DIV error.

I need to get the percentage to display or have N/A display if the total is zero.

Then you just need to wrap the IFERROR around the formula you have above.
=IFERROR(F45/(F45+G45),"N/A")

Does that do the trick?

Thanks for being patient with me.

What do you mean by wrap?

NVM. I got it. Thanks so much for your help. Maybe will get the boss to smile.

"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)

Wrap just meant put your formula in the middle of the IFERROR formula.
It's the formula I put in the same post.

Glad you got it sorted now & hope the boss appreciates your efforts :)