Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If help
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If help
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If help
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,FA LSE) 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 On Tue, 7 Nov 2006 12:14:02 -0800, 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If help
zzzzzzzzzzz?
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|