Hi,

Try

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

Format C5 as required

VBA Noob


Ellen wrote:
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.

--
Best Regards,
Ellen