Hi!

If I understand what you want:

Goal.....Reached.....Incentive.....10%.....7.5%... ..5%
1700......1075..........53.75..................... .............X
1700......1300..........97.50..................... .X............
1700......2000...........200............X......... ...............
1700.......849..............0..................... ...................

Enter this formula in E3 and copy across to G3:

=IF($D30,IF($D3/$C3=E$1,"X",""),"")

Biff

"tmac" wrote in message
...

Thanks a million!

Thanks for correcting my calculation - I was guessing when I typed so I
was wrong!! There was no incentive if they didn't reach 50% of goal.
We actually was leaning toward 100% participation and that didn't
happen.

I am learning on formulars so thanks so much for helping out. Another
question? Once answer is received how can the formular be edited to
have $amount result into correct percentage column?

Goal Reached Incentive 10% 7.5% 5%
B3 C3 D3 E3 F3 G3


--
tmac
------------------------------------------------------------------------
tmac's Profile:
http://www.excelforum.com/member.php...o&userid=33890
View this thread: http://www.excelforum.com/showthread...hreadid=536683