Thread: A CAP?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M Thompson M Thompson is offline
external usenet poster
  
Posts: 37
Default A CAP?
does anyone know how I can put a cap of 400 on this formula?

=IF(H9="","",-MAX(0,MIN(H9,100)*0.05)+-MAX(0,(H9-100)*0.02))

Thanks so much and have...
--
OneFineDay
Reply With QuoteReply With Quote