formula
 

Hi,
I need to know how to setup a formula for: If i type in a letter, which
represents a subject and once I type in the letter; when i type in the
amounts the rate of pay would automatically populate. Is this possible?

Hope someone can help me.
Thanks,
Anita

formula
 

It should be, but we'd need more information. Do you have a table that shows
the letter in a column and the value to get rate of pay in another column?

"anita" wrote:

Hi,
I need to know how to setup a formula for: If i type in a letter, which
represents a subject and once I type in the letter; when i type in the
amounts the rate of pay would automatically populate. Is this possible?

Hope someone can help me.
Thanks,
Anita

formula
 

Anita, look up the following function in Excel's help facility.

VLOOKUP

This is one way of getting the results you need. Once you've examined the
formula's help you can re-post with additional details.

Hope this sets you off on the right path.
--
Kevin Backmann


"anita" wrote:

Hi,
I need to know how to setup a formula for: If i type in a letter, which
represents a subject and once I type in the letter; when i type in the
amounts the rate of pay would automatically populate. Is this possible?

Hope someone can help me.
Thanks,
Anita