Forum Discussion
GCWESTWOOD
Feb 05, 2020Copper Contributor
formula help
Hi,
I'm looking to create a formula where the sum depends on the number entered in the first cell,
for example the 1st variable can be 1-2, 2nd is 3-4 and 3rd is 5+.
If the first variable is 1-2 then hours worked should be multiplied by 5,
if the 1st variable is 3 or 4 then ours worked should be multiplied by 7.5,
if its 5 or more then its ours worked multiplied by 10
In the example below the 1st answer would be 15 and the 2nd would be 30.
Hope that makes sense!
| No of Quals | Hours Worked | Total Due |
| 1 | 3 | |
| 5 | 3 |
- Try:
=B2*IF(A2<=2, 5, IF(A2<=4, 7.5, 10))
7 Replies
- SergeiBaklanDiamond Contributor
- GCWESTWOODCopper Contributorthanks @sergei bakan but this didn't work for me.
- SergeiBaklanDiamond Contributor
- SaviaIron ContributorTry:
=B2*IF(A2<=2, 5, IF(A2<=4, 7.5, 10))- GCWESTWOODCopper Contributor
Savia is it possible to add in a step that if A2 = 0 then equals 0??
- SaviaIron ContributorSure:
=B2*IF(A2=0, 0, IF(A2<=2, 5, IF(A2<=4, 7.5, 10)))
- GCWESTWOODCopper Contributorexcellent - this worked perfectly! Thank you!