Assigning a word to a number
=IF(A4="","N/A",A4/A5)
"MJ" wrote:
Thank you for your assistance. I'm wondering how to recognize this as a
word, for instance.
(Cell A3) Apples -5
(Cell A4) Pears - 7
(Cell A5) Total - 12
I find the percentage by calculating 7/12 = 58%
Now, suppose there were no pears, that will be 0%. How do I change from 0%
to N/A on the cell?
Would that be... =A4/A5=If(NOT(A2<=0%), "xxxx", "N/A") on the same cell as
calculating 0/12?
Thanks!
|