Thanks for all the help, I was able to overcome one of my problems,
which leaves me with one final question. I am curious if there is a
formula that allow me to do the following.
I would like to offer a productivity Gain/Share model if work is
completed ahead of schedule. For every 5% increase in production i
would like a .5% revenue gain, with unlimited upside. For every 5%
loss in production I would take a .5% deduction limited at 4%. Is
there one formula that could do this? Thanks again for all your help
--
wmaughan
------------------------------------------------------------------------
wmaughan's Profile:
http://www.excelforum.com/member.php...o&userid=29743
View this thread:
http://www.excelforum.com/showthread...hreadid=494600