SOLVED

Excel formula help (If function I think)

Copper Contributor

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

2 Replies
best response confirmed by bell123321 (Copper Contributor)
Solution

@bell123321 

=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!
1 best response

Accepted Solutions
best response confirmed by bell123321 (Copper Contributor)
Solution

@bell123321 

=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.

View solution in original post