Thread: Getting "N/A"
View Single Post
  #1   Report Post  
Planko Planko is offline
Junior Member
 
Posts: 9
Default Getting "N/A"

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.