its my second week trying to understand why this formula does not give
me proper result... and i think im gonna spend my whole life trying
unless i get a help from you guys..

the concept of the formula is that the pay is determined by increase in
sales achievement, where there are 4 levels of sales, the more a
salesman achieve, the more is the pay.

the file containing the formula is attached.... i really hope i dont
spend my whole life on this :(


+-------------------------------------------------------------------+
|Filename: Formula.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4910 |
+-------------------------------------------------------------------+

--
blindhunter
------------------------------------------------------------------------
blindhunter's Profile: http://www.excelforum.com/member.php...o&userid=35600
View this thread: http://www.excelforum.com/showthread...hreadid=553733

I got an 'invlaid attachement specified' message. Can you just copy the
formula into a message instead?

"blindhunter" wrote:


its my second week trying to understand why this formula does not give
me proper result... and i think im gonna spend my whole life trying
unless i get a help from you guys..

the concept of the formula is that the pay is determined by increase in
sales achievement, where there are 4 levels of sales, the more a
salesman achieve, the more is the pay.

the file containing the formula is attached.... i really hope i dont
spend my whole life on this :(


+-------------------------------------------------------------------+
|Filename: Formula.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4910 |
+-------------------------------------------------------------------+

--
blindhunter
------------------------------------------------------------------------
blindhunter's Profile: http://www.excelforum.com/member.php...o&userid=35600
View this thread: http://www.excelforum.com/showthread...hreadid=553733

The problem is that you are checking backwards..

at 34% .. of course it is larger than 15% so it get stuck there and
never get beyond that point, try this:

=IF(D3=A27,(B15/12)*B27,IF(D3=A26,(B15/12)*B26,IF(D3=A25,(B15/12)*B25,IF(D3=A24,(B15/12)*B24))))

HTH


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=553733

A BIG THANKS FOR YOU BEARACADE... i cant believe its working!!! i am
celebrating now i swear.. i tempt to believe them when they say
"sometimes, you should look at things from different angle".. thank you
for your help :)

tim m, though the issue is solved, but i thank you for offering to
help.. here you go with the formula:

=IF(D3=A24,(B15/12)*B24,IF(D3=A25,(B15/12)*B25,IF(D3=A26,(B15/12)*B26,IF(D3=A27,(B15/12)*B27))))


--
blindhunter
------------------------------------------------------------------------
blindhunter's Profile: http://www.excelforum.com/member.php...o&userid=35600
View this thread: http://www.excelforum.com/showthread...hreadid=553733