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