Forum Discussion
Solved
Excel formula help (If function I think)
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 C1...
=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.
=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.
- You are a star! Thank you so much Hans!
