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