Thread: How to put a cap on an amount?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ross Ross is offline
external usenet poster
  
Posts: 152
Default How to put a cap on an amount?
Hi Everyone

The formula that I already have is:
=IF(B5<0.01,0,IF(B5<6001,(B5*0.012)+18,IF(B56000, (B5*0.009)+18,0))) I need
to add something to cap the result at 500. Can someone help?

Thanks...
--
smither fan
Reply With QuoteReply With Quote