Thread: Formula help
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Formula help

Errata ....

I wrote:
=IF(C2 <= 6, 0,
MIN(10,K2)*17+MAX(0,K2-10)*33+MAX(0,K2-30)*50)


That should be simply:

=IF(C2 <= 6, 0, K2*17+MAX(0,K2-10)*33+MAX(0,K2-30)*50)