Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation of a number in a range
I need to create a formula for the following:
If A1=any number from 0 to 100,000 then A1*.15 If A1=any number from 101,000 to 250,000 then A1*.12 If A1=any number from 251,000 to 500,000 then A1*.10 Any suggestions? Thanks much! -- Krista |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation of a number in a range
Try
=IF(A15<100000,A15*0.15,IF(A15<250000,A15*0.12,A15 *0.1)) "Krista" wrote: I need to create a formula for the following: If A1=any number from 0 to 100,000 then A1*.15 If A1=any number from 101,000 to 250,000 then A1*.12 If A1=any number from 251,000 to 500,000 then A1*.10 Any suggestions? Thanks much! -- Krista |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation of a number in a range
=A1*CHOOSE((A10)+(A1100000)+(A1250000),0.15,0.1 2,0.1)
this should get you what you need. "Krista" wrote: I need to create a formula for the following: If A1=any number from 0 to 100,000 then A1*.15 If A1=any number from 101,000 to 250,000 then A1*.12 If A1=any number from 251,000 to 500,000 then A1*.10 Any suggestions? Thanks much! -- Krista |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation of a number in a range
=A1*LOOKUP(A1,{0,100001,250001},{0.15,0.12,1})
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Krista" wrote in message ... I need to create a formula for the following: If A1=any number from 0 to 100,000 then A1*.15 If A1=any number from 101,000 to 250,000 then A1*.12 If A1=any number from 251,000 to 500,000 then A1*.10 Any suggestions? Thanks much! -- Krista |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation of a number in a range
SORRY...REPLACE "A15" WITH "A1"
"danw" wrote: Try =IF(A15<100000,A15*0.15,IF(A15<250000,A15*0.12,A15 *0.1)) "Krista" wrote: I need to create a formula for the following: If A1=any number from 0 to 100,000 then A1*.15 If A1=any number from 101,000 to 250,000 then A1*.12 If A1=any number from 251,000 to 500,000 then A1*.10 Any suggestions? Thanks much! -- Krista |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation of a number in a range
Thanks much everyone!
-- Krista "Bob Phillips" wrote: =A1*LOOKUP(A1,{0,100001,250001},{0.15,0.12,1}) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Krista" wrote in message ... I need to create a formula for the following: If A1=any number from 0 to 100,000 then A1*.15 If A1=any number from 101,000 to 250,000 then A1*.12 If A1=any number from 251,000 to 500,000 then A1*.10 Any suggestions? Thanks much! -- Krista |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation of a number in a range
Hmm, this is fun:)
Alright, create a little table first (dashes - signify new column) ......D - .....E - .................F 1) 0 - 100000 - ...........0.15 2) 100001 - 250000 - 0.12 3) 251000 - 500000 - 0.10 Now your formula is: =A1*(VLOOKUP(A1,$D$1:$F$3,3)) That's it:) I know someone beat me to this, but I had this window open for an hour:) Krista wrote: I need to create a formula for the following: If A1=any number from 0 to 100,000 then A1*.15 If A1=any number from 101,000 to 250,000 then A1*.12 If A1=any number from 251,000 to 500,000 then A1*.10 Any suggestions? Thanks much! -- Krista |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop Excel interpretting a number range as a date? | Excel Discussion (Misc queries) | |||
End of range changes when I add a number | New Users to Excel | |||
how can I return a value in excel that looks at a range of number | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
How to add one number to a range of numbers | Excel Worksheet Functions |