Originally Posted by Planko

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.