May 24 2021 11:10 AM
Hi all,
I hope someone can help I am not great with formulas.
I am wanting a formula to do the following:
Example:
If Cell C104 has a value between 2-4 result = £5 x number entered in C104. If Cell C104 has a value between 4-9 result = £4 x C104, lastly if Cell C104 is 10 or more result = £3.50 x C104.
Hope someone can help
May 24 2021 11:27 AM
Solution=IF(C104>=10,3.5,IF(C104>=4,4,IF(C104>=2,5,10)))*C104
or
=LOOKUP(C104,{0,2,4,10},{10,5,4,3.5})*C104
P.S. you didn't specify what the result should be if C104 is less than 2. I arbitrarily multiplied with 10.
May 24 2021 11:45 AM
May 24 2021 11:27 AM
Solution=IF(C104>=10,3.5,IF(C104>=4,4,IF(C104>=2,5,10)))*C104
or
=LOOKUP(C104,{0,2,4,10},{10,5,4,3.5})*C104
P.S. you didn't specify what the result should be if C104 is less than 2. I arbitrarily multiplied with 10.