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