formula

  • Thread starter Thread starter anita
  • Start date Start date
A

anita

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
 
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, 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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to type each letter of the alphabet automatically in a specific color in Word? 0
What formula should I use? 1
Excel Use COUNTIF across a range of cells with formulas 0
Formula for formatting font/style 2
bookkeeping-payment confirmation 7
Creating sequential numbers plus a letter 4
IF formula.. 3
Excel Help to copy information from one row at a time to another sheet 1

Back
Top