Hi there...
Is there any way to make the following formula shorter??? This is
ridiculous, and I need the formula to evaluate such as it does... Sorry for
the crosspost, but I am desperate!!!!
=IF(F7>=27000,(19200/$G$4),IF(F7>=26500,(F7-100)*($G$4)/($G$4),IF(F7>=25000,(F7-200)*($G$4)/($G$4),IF(F6=6500,(24100)-(P3+P4)/($G$4)*($G$4),IF(F6=6000,(24100)-(P3+P4)/($G$4)*($G$4),IF(F6=5500,(24100)-(P3+P4)/($G$4)*($G$4),IF(F6=5000,(24100)-(P3+P4)/($G$4)*($G$4),IF(F7>=17000,(12000/$G$4),(F7-200)*($G$4)/($G$4)))))))))
Thank you
Doug
Bookmarks