Help with formula
 

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.

Help with formula
 

Hi Leisl

Try this:

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

HTH
Jean-Guy

"Leisl" wrote:

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.

Help with formula
 

Hi, I tried and it just gave me 0 value


"pinmaster" wrote:

Hi Leisl

Try this:

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

HTH
Jean-Guy

"Leisl" wrote:

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.

Help with formula
 

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

"pinmaster" wrote:

Hi Leisl

Try this:

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

HTH
Jean-Guy

"Leisl" wrote:

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.

Help with formula
 

Glad I could help!

Jean-Guy

"Leisl" wrote:

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

"pinmaster" wrote:

Hi Leisl

Try this:

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

HTH
Jean-Guy

"Leisl" wrote:

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.