Help with formula

[Guest]

hi, pls help me construct the following formula

in cell A1 there is a value, eg 15,678

In cell B1 I want it to return an answer based on what is in cell A1 so if
A1 is 10,000 or less I want B1 to return a value of 0, if cell A1 is 10,001 -
15,000 I want cell B1 to return a value of 2% of the value of A1, if A1 is
15,001 - 20,000 I want B1 to return a value of 3% of the value of A1 and
finally if cell A1 is 20,001 or more I want cell B1 to return a value of 4%
of the value of cell A1!!

If there is anyone out there who can help I'll be really grateful. Thank you.

 

[Guest]

Hi Leisl

Try this:

=A1*(LOOKUP(A1,{0,10001,15001,20001},{0,2,3,4})&"%")

HTH
Jean-Guy

 

[Guest]

Hi, I tried and it just gave me 0 value

Hi Leisl

Try this:

=A1*(LOOKUP(A1,{0,10001,15001,20001},{0,2,3,4})&"%")

HTH
Jean-Guy

 

[Guest]

Ignore me, I'm being a muppet, this works perfectly, thank you.

 

[Guest]

Glad I could help!

Jean-Guy

Ignore me, I'm being a muppet, this works perfectly, thank you.