| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
