Thread: calculate ranges
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
topola
 
Posts: n/a
Default calculate ranges
=MIN(50000,A1)*50%+MIN(MAX(0,A1-50000)*40%,(100000-50000)*40%)+MAX(0,A1-100000)*30%
--
topola

Reply With QuoteReply With Quote