Answers!
There was a small mistake in question
I have slightly modified it as
What is the excel formula of Up to 5 hours is 10 per hour Next 2 hours is 20 per hour Next 4 hours is 30 per hour Next 3 hours is 40 per hour Greater 14 is 50 per hour
Hours
Rate
0-5
10
5-7
20 per hour+50 extra(10*5)
7-11
30 per hour+90 extra(10*5+20*2)
11-14
40 per hour+210 extra(10*5+20*2+30*4)
>14
50 per hour+330 extra(10*5+20*2+30*4+40*3)
The Answer is
=IF(C9<=5,10*C9,IF(C9<=7,20*(C9-5)+50,IF(C9<=11,30*(C9-7)+90,IF(C9<=14,40*(C9-11)+210,50*(C9-14)+330))))
Download Excel file
EXCEL QUESTION IF COMMAND.xlsx
Comment
Answer the question...
There was a small mistake in question
I have slightly modified it as
What is the excel formula of Up to 5 hours is 10 per hour Next 2 hours is 20 per hour Next 4 hours is 30 per hour Next 3 hours is 40 per hour Greater 14 is 50 per hour
| Hours | Rate |
| 0-5 | 10 |
| 5-7 | 20 per hour+50 extra(10*5) |
| 7-11 | 30 per hour+90 extra(10*5+20*2) |
| 11-14 | 40 per hour+210 extra(10*5+20*2+30*4) |
| >14 | 50 per hour+330 extra(10*5+20*2+30*4+40*3) |
The Answer is
=IF(C9<=5,10*C9,IF(C9<=7,20*(C9-5)+50,IF(C9<=11,30*(C9-7)+90,IF(C9<=14,40*(C9-11)+210,50*(C9-14)+330))))
Download Excel file
EXCEL QUESTION IF COMMAND.xlsx
Comment