What am I doing wrong?

I have set up the following if formula what I have done wrong -

As follows:

if(G8>=163000, 1000, if(g8>187450, 3000, if(g8>234312, 3000, if(g8>244500,
4000))))

what am trying to accomplish is a bonus if employees hit 100% of plan which
is the 163,000 the get $1,000 - when they hit (which is 115% of plan)
$187,450 they get 3,000 bonus when they hit $203750 or (125%) they get $3,000
and when they it 244,500 (150% they get 4,000).

But it either won't go past the 163000 when I change numbers around or it
goes directly to the 4000? I cannot figure out - though I am not very savy
at these formulas I am just learning. - I guess one more question is where
is a good place to take a class or something on formulas.

All your help is greatly appreciated.

Change the order of your test. If G8 is 250000, the first test is true
already so it doesn't look any further

--
Kind regards,

Niek Otten

"jewels" <[email protected]> wrote in message
news:[email protected]...
>I have set up the following if formula what I have done wrong -
>
> As follows:
>
> if(G8>=163000, 1000, if(g8>187450, 3000, if(g8>234312, 3000, if(g8>244500,
> 4000))))
>
> what am trying to accomplish is a bonus if employees hit 100% of plan
> which
> is the 163,000 the get $1,000 - when they hit (which is 115% of plan)
> $187,450 they get 3,000 bonus when they hit $203750 or (125%) they get
> $3,000
> and when they it 244,500 (150% they get 4,000).
>
> But it either won't go past the 163000 when I change numbers around or it
> goes directly to the 4000? I cannot figure out - though I am not very
> savy
> at these formulas I am just learning. - I guess one more question is
> where
> is a good place to take a class or something on formulas.
>
> All your help is greatly appreciated.

Try

=IF(G8>=244500,4000,IF(G8>234312,3000,IF(G8>187450,2000,IF(G8>163000, 1000,
0))))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jewels" <[email protected]> wrote in message
news:[email protected]...
> I have set up the following if formula what I have done wrong -
>
> As follows:
>
> if(G8>=163000, 1000, if(g8>187450, 3000, if(g8>234312, 3000, if(g8>244500,
> 4000))))
>
> what am trying to accomplish is a bonus if employees hit 100% of plan
which
> is the 163,000 the get $1,000 - when they hit (which is 115% of plan)
> $187,450 they get 3,000 bonus when they hit $203750 or (125%) they get
$3,000
> and when they it 244,500 (150% they get 4,000).
>
> But it either won't go past the 163000 when I change numbers around or it
> goes directly to the 4000? I cannot figure out - though I am not very
savy
> at these formulas I am just learning. - I guess one more question is
where
> is a good place to take a class or something on formulas.
>
> All your help is greatly appreciated.

Hi jewels,

I also noted that you have, in your argument, 2 separate conditions that would yield the same value if true, if that is not just a typo, then why do you need that?

Then simplify the formula I posted to: =LOOKUP(G8,{0,0;163000,1000;187450,3000;244500,4000})


or your formula, fixed:

=IF(G8>244500,4000,IF(G8>187450,3000,IF(G8>=163000,1000,0)))

Thank you soo much. I am just learning all these formulas - yeah one of the
bonuses is the same amount so I guess I really don't need the two numbers in
there.

I really appreciate all the help.

Do you know of a good place to learn about all different functions = I live
in Massachusetts.

"Vito" wrote:

>
> Hi,
>
> Try this instead:
>
> I have assumed anything less than 163,000 would result in 0:
>
> =LOOKUP(G8,{0,0;163000,1000;187450,3000;23412,3000;244500,4000})
>
>
> --
> Vito
> ------------------------------------------------------------------------
> Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
> View this thread: http://www.excelforum.com/showthread...hreadid=491796
>
>

Thank you! sooo much!

"Niek Otten" wrote:

> Change the order of your test. If G8 is 250000, the first test is true
> already so it doesn't look any further
>
> --
> Kind regards,
>
> Niek Otten
>
> "jewels" <[email protected]> wrote in message
> news:[email protected]...
> >I have set up the following if formula what I have done wrong -
> >
> > As follows:
> >
> > if(G8>=163000, 1000, if(g8>187450, 3000, if(g8>234312, 3000, if(g8>244500,
> > 4000))))
> >
> > what am trying to accomplish is a bonus if employees hit 100% of plan
> > which
> > is the 163,000 the get $1,000 - when they hit (which is 115% of plan)
> > $187,450 they get 3,000 bonus when they hit $203750 or (125%) they get
> > $3,000
> > and when they it 244,500 (150% they get 4,000).
> >
> > But it either won't go past the 163000 when I change numbers around or it
> > goes directly to the 4000? I cannot figure out - though I am not very
> > savy
> > at these formulas I am just learning. - I guess one more question is
> > where
> > is a good place to take a class or something on formulas.
> >
> > All your help is greatly appreciated.
>
>
>

Thanks it works perfectly!

"Bob Phillips" wrote:

> Try
>
> =IF(G8>=244500,4000,IF(G8>234312,3000,IF(G8>187450,2000,IF(G8>163000, 1000,
> 0))))
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "jewels" <[email protected]> wrote in message
> news:[email protected]...
> > I have set up the following if formula what I have done wrong -
> >
> > As follows:
> >
> > if(G8>=163000, 1000, if(g8>187450, 3000, if(g8>234312, 3000, if(g8>244500,
> > 4000))))
> >
> > what am trying to accomplish is a bonus if employees hit 100% of plan
> which
> > is the 163,000 the get $1,000 - when they hit (which is 115% of plan)
> > $187,450 they get 3,000 bonus when they hit $203750 or (125%) they get
> $3,000
> > and when they it 244,500 (150% they get 4,000).
> >
> > But it either won't go past the 163000 when I change numbers around or it
> > goes directly to the 4000? I cannot figure out - though I am not very
> savy
> > at these formulas I am just learning. - I guess one more question is
> where
> > is a good place to take a class or something on formulas.
> >
> > All your help is greatly appreciated.
>
>
>

Another possible solutions

=((G8>163000)+(G8>187450)+(G8>201750)+(G8>244500))*1000

=(MATCH((G8-1)/163000,{0;1;1.15;1.25;1.5},1)-1)*1000



--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )




"Bob Phillips" <[email protected]> wrote in message
news:OH7DMt$%[email protected]...
> Try
>
> =IF(G8>=244500,4000,IF(G8>234312,3000,IF(G8>187450,2000,IF(G8>163000,
> 1000,
> 0))))
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "jewels" <[email protected]> wrote in message
> news:[email protected]...
>> I have set up the following if formula what I have done wrong -
>>
>> As follows:
>>
>> if(G8>=163000, 1000, if(g8>187450, 3000, if(g8>234312, 3000,
>> if(g8>244500,
>> 4000))))
>>
>> what am trying to accomplish is a bonus if employees hit 100% of plan
> which
>> is the 163,000 the get $1,000 - when they hit (which is 115% of plan)
>> $187,450 they get 3,000 bonus when they hit $203750 or (125%) they get
> $3,000
>> and when they it 244,500 (150% they get 4,000).
>>
>> But it either won't go past the 163000 when I change numbers around or it
>> goes directly to the 4000? I cannot figure out - though I am not very
> savy
>> at these formulas I am just learning. - I guess one more question is
> where
>> is a good place to take a class or something on formulas.
>>
>> All your help is greatly appreciated.
>
>