If help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a spreadsheet and need to have a formula that will show:
If "Driller, then ___(cell) =$21.25
or Derrickman, then cell # ___ =$ 22.31
or Floorman then cell # ____ = $21.25
Example:
When I enter the employees "position" in A7 I want Excel to determine the
hourly rate for that position and input it in C5 for calculation
automatically instead of having to manually input hourly rate based on the
position name I show in A7 or other locations.
 
Hi,

Try

=IF(A7="Driller",21.25,IF(A7="Derrickman",22.31,IF(A7="Floorman",21.25,"")))

Format C5 as required

VBA Noob
 
On a separate worksheet enter in Column A the position.

In column B enter the rate for that position.

Assuming 10 positions and 10 rates.

In Sheet1 enter "Driller" in A7

In C5 enter this formula.........=VLOOKUP(C5,Sheet2!$A$1:$B$10,2,FALSE)

You could also have a Data Validation drop-down list in A7 from which you could
choose the position.

See Debra Dalgleish's site for more on DV drop-downs.

http://www.contextures.on.ca/xlDataVal01.html

See Debra's help on VLOOKUP also.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP
 
Back
Top