weekly salary | ee | er | weeks | salary |
200-339.99 | 11.9 | 23.8 | 4 | |
340-449.99 | 17.4 | 34.8 | ||
450-609.99 | 23.3 | 46.6 | ||
610-759.99 | 30.1 | 60.2 |
weekly salary | ee | er | weeks | salary | |
0 | |||||
200 | 11.9 | 23.8 | 4 | 340 | 17.4 |
340 | 17.4 | 34.8 | |||
450 | 23.3 | 46.6 | |||
610 | 30.1 | 60.2 | |||
760 |
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Salary from | to | ee | er | weeks | salary | Result | ||
2 | 0 | 199.99 | 4 | 600 | 93.2 | ||||
3 | 200 | 339.99 | 11.9 | 23.8 | |||||
4 | 340 | 449.99 | 17.4 | 34.8 | |||||
5 | 450 | 609.99 | 23.3 | 46.6 | |||||
6 | 610 | 759.99 | 30.1 | 60.2 | |||||
Sheet418 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G2 | =LOOKUP(F2,A2:A6,C2:C6)*E2 |