Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula that will populate the hourly rate cell with the correct rate according to the job description. i.e. if I type stagehand in O8, than M8 will enter 37.71, Rigger= 39.46, Head=44.25.
There are three variable rates.
Solved by A. U. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
24/05/2018 - 04:36
Auditing for Music Festivals
Excelchat Expert
24/05/2018 - 04:36
Hello
User
24/05/2018 - 04:37
Hi. I am a little tired, want to make a equation that will populate salary rate based upon job description
Excelchat Expert
24/05/2018 - 04:37
Okay, to do that we need a predefined table which will consist the different rates and job descriptions.
User
24/05/2018 - 04:38
Stagehand 37.71
User
24/05/2018 - 04:38
Rigger 39.46
User
24/05/2018 - 04:38
Dept head 44.25
Excelchat Expert
24/05/2018 - 04:39
Please look at the spreadsheet on the right.
User
24/05/2018 - 04:39
got it. looks right
Excelchat Expert
24/05/2018 - 04:40
Okay, now we can write a IF formula. Let's assume we will input job description in A1
Excelchat Expert
24/05/2018 - 04:41
Now this formula =IF(A1=E2,F2,IF(A1=E3,F3,F4)) in A2 will give you the rates according to A1.
Excelchat Expert
24/05/2018 - 04:42
Please test it and let me know.
Excelchat Expert
24/05/2018 - 04:45
The if formula is comparing A1 value with E2, E3.
Excelchat Expert
24/05/2018 - 04:48
Are you there?
User
24/05/2018 - 04:49
Sorry got distracted at work, but this looks great. thanks. I have been working for 90 plus days straight.
Excelchat Expert
24/05/2018 - 04:50
Wow, man. You are amazing.
Excelchat Expert
24/05/2018 - 04:50
Let me know if you need anything else.
User
24/05/2018 - 04:51
will do. thank you
Excelchat Expert
24/05/2018 - 04:51
The session will end in 4 minutes. Of course if you need more time you can extend the session.
Excelchat Expert
24/05/2018 - 04:52
To do that you have to select YES when you are asked.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.