how do I give a word a numeric value??

L

Liz

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.
 
L

Lorne

Liz said:
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.
Click to expand...

Put the number 60 in the cell then use format - custom and enter the format
as "Wheat".
 
S

Sandy Mann

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top