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

As follows:

if(G8=163000, 1000, if(g8187450, 3000, if(g8234312, 3000, if(g8244500,
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" wrote in message
...
I have set up the following if formula what I have done wrong -

As follows:

if(G8=163000, 1000, if(g8187450, 3000, if(g8234312, 3000, if(g8244500,
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,

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

Try

=IF(G8=244500,4000,IF(G8234312,3000,IF(G8187450 ,2000,IF(G8163000, 1000,
0))))

--

HTH

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


"jewels" wrote in message
...
I have set up the following if formula what I have done wrong -

As follows:

if(G8=163000, 1000, if(g8187450, 3000, if(g8234312, 3000, if(g8244500,
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,400 0})


or your formula, fixed:

=IF(G8244500,4000,IF(G8187450,3000,IF(G8=163000 ,1000,0)))


--
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 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" wrote in message
...
I have set up the following if formula what I have done wrong -

As follows:

if(G8=163000, 1000, if(g8187450, 3000, if(g8234312, 3000, if(g8244500,
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(G8234312,3000,IF(G8187450 ,2000,IF(G8163000, 1000,
0))))

--

HTH

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


"jewels" wrote in message
...
I have set up the following if formula what I have done wrong -

As follows:

if(G8=163000, 1000, if(g8187450, 3000, if(g8234312, 3000, if(g8244500,
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

=((G8163000)+(G8187450)+(G8201750)+(G8244500)) *1000

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



--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )




"Bob Phillips" wrote in message
...
Try

=IF(G8=244500,4000,IF(G8234312,3000,IF(G8187450 ,2000,IF(G8163000,
1000,
0))))

--

HTH

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


"jewels" wrote in message
...
I have set up the following if formula what I have done wrong -

As follows:

if(G8=163000, 1000, if(g8187450, 3000, if(g8234312, 3000,
if(g8244500,
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.