Getting "N/A"

[Planko]

I have a pretty simple one but cannot seem to get it to do what I want.

I am using:

=F45/F45+G45

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

I have also tried this as recommended by a friend:

=IF(SUM(I45/I45+J45)>0,"N/A",SUM(I45/I45+J45))

That one messes up my calculation.

Thanks for any help

 

[Spencer101]

I have a pretty simple one but cannot seem to get it to do what I want

I am using

=F45/F45+G4

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

I have also tried this as recommended by a friend

=IF(SUM(I45/I45+J45)>0,"N/A",SUM(I45/I45+J45)

That one messes up my calculation

Thanks for any help

=IFERROR(F45/F45+G45),"N/A")* will work if you're using Excel 2007 o
later.

 

[joeu2004]

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)