Thread: calculate ranges
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
topola
 
Posts: n/a
Default calculate ranges
=IF(A1100000,45000+(A1-100000)*0.3,IF(A150000,25000+(A1-50000)*0.4,A1*0.5))
--
HTH
Tomek Polak, http://vba.blog.onet.pl

Reply With QuoteReply With Quote