| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I give a word a numeric value??
I need to give "wheat" a value of 60 so that the formula can be:
(unload weight/60)*rate=amt I also need to give "corn" a value of 56 to calc the same amt. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I give a word a numeric value??
"Liz" wrote in message
... I need to give "wheat" a value of 60 so that the formula can be: (unload weight/60)*rate=amt I also need to give "corn" a value of 56 to calc the same amt. Put the number 60 in the cell then use format - custom and enter the format as "Wheat". |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I give a word a numeric value??
With the Unloaded weight in A1 and the Rate in A3 try:
=IF(A2="","",IF(OR(A2={"Wheat","Corn"}),A1/IF(A2="Wheat",60,40)*A3,"Error in Data")) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Liz" wrote in message ... I need to give "wheat" a value of 60 so that the formula can be: (unload weight/60)*rate=amt I also need to give "corn" a value of 56 to calc the same amt. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I give up, trying to sum with non numeric cells. | Excel Worksheet Functions | |||
| How can I give text a changeable numeric value? | Excel Worksheet Functions | |||
| give text a dollar numeric value | Excel Worksheet Functions | |||
| convert numeric to word | Excel Discussion (Misc queries) | |||
| How do I give a hyperlink of TOC of Word in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
