Quote:
Originally Posted by Spencer101
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%.