how do I give a word a numeric value??

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

 

[Lorne]

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

 

[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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk