how do I give a word a numeric value??

's Computer Specifications

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.

's Computer Specifications

"Liz" <(E-Mail Removed)> wrote in message
news:6943C467-EB20-45F9-94FA-(E-Mail Removed)...
>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".

's Computer Specifications

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 Removed)
Replace @mailinator.com with @tiscali.co.uk

"Liz" <(E-Mail Removed)> wrote in message
news:6943C467-EB20-45F9-94FA-(E-Mail Removed)...
>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.
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re-map numeric keys to give a tab key?	Boppy	Windows Vista General Discussion	0	7th Oct 2008 01:01 AM
I give up, trying to sum with non numeric cells.	HammerJoe@gmail.com	Microsoft Excel Worksheet Functions	2	20th Jun 2008 08:53 AM
How can I give text a changeable numeric value?	=?Utf-8?B?U3RldmVfRGFsbGFz?=	Microsoft Excel Worksheet Functions	3	2nd Oct 2007 11:47 PM
give text a dollar numeric value	=?Utf-8?B?R2F2?=	Microsoft Excel Worksheet Functions	6	5th Jun 2007 01:57 PM
Alt key and numeric pad no longer give me special characters.????	=?Utf-8?B?R3VpdGFybWFu?=	Microsoft Word Document Management	1	20th May 2005 02:54 PM