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