Thread: Formula Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Formula Help
maybe...
=IF((C8-C9)*0.04350000,75000,IF((C8-C9)*0.01<25000,25000,(C8-C9)*0.01))



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

--

Dave Peterson
Reply With QuoteReply With Quote