Excel formula help (If function I think)

New Contributor

Hi all,


I hope someone can help I am not great with formulas.


I am wanting a formula to do the following:



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

2 Replies
best response confirmed by bell123321 (New Contributor)






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!