Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assigning Row Number to TextBox | Excel Discussion (Misc queries) | |||
Assigning words to a number | Excel Discussion (Misc queries) | |||
Assigning values to a word in a drop down box | Excel Discussion (Misc queries) | |||
Help assigning a number to a word | Excel Discussion (Misc queries) | |||
Assigning a number value to a letter? | Excel Discussion (Misc queries) |