LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mj mj is offline
external usenet poster
 
Posts: 78
Default Assigning a word to a number

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Assigning Row Number to TextBox Ayo Excel Discussion (Misc queries) 0 May 30th 08 08:24 PM
Assigning words to a number Prelate Excel Discussion (Misc queries) 1 March 1st 08 06:09 PM
Assigning values to a word in a drop down box Aleyna0515 Excel Discussion (Misc queries) 1 October 8th 07 02:23 AM
Help assigning a number to a word modicon2 Excel Discussion (Misc queries) 7 August 21st 06 03:37 AM
Assigning a number value to a letter? Orphan86 Excel Discussion (Misc queries) 3 August 30th 05 11:45 PM


All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"