Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array formula returning wrong results | Excel Discussion (Misc queries) | |||
wrong year | Excel Worksheet Functions | |||
macro results wrong | Charts and Charting in Excel | |||
multi-level subtotals are in the wrong position | Excel Worksheet Functions | |||
IF function displays wrong amount | Excel Worksheet Functions |