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 get 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 or later..

Well, I tried it and got:

You've entered too few arguments for this function.

To get help help with this function, click ok to close message. Then click the Insert Function button.

I do this but am not sure what to add in the IFERROR spot.

Sorry, my bad. I was typing the reply on my phone and missed a bracket.

Try =IFERROR((F45/F45+G45),"N/A")

Thanks for the help so far.

That worked to put "N/A" in the field but removes my calculation into a percentage. So when my total equals 0 I get "N/A." But when I actually have a number in F45 or G45 it just adds them up instead of dividing them.

Ex: F45 has 1 and G45 has 1 I get 200% instead of 50%.

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.