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

What am I doing wrong?
 

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.

What am I doing wrong?
 

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

What am I doing wrong?
 

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.

What am I doing wrong?
 

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

What am I doing wrong?
 

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

What am I doing wrong?
 

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.

What am I doing wrong?
 

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.

What am I doing wrong?
 

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.