=IF((C8-C9)*.04350000,75000,IF((C8-C9)*.01<25000,25000,(C8-C9)*.01))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"heater" wrote:

I need a formula to do the following:
If(c8-c9)*.04350000,75000,if(c8-c9)*.01<25000,25000,if not then (c8-c9)*.01