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

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

=A1*CHOOSE((A1>0)+(A1>100000)+(A1>250000),0.15,0.12,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

=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" <(E-Mail Removed)> wrote in message
news:954B627B-A655-42AE-9096-(E-Mail Removed)...
> 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

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

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" <(E-Mail Removed)> wrote in message
> news:954B627B-A655-42AE-9096-(E-Mail Removed)...
> > 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
>
>
>

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