View Single Post
  #6   Report Post  
Harlan Grove
 
Posts: n/a
Default

Dana DeLouis wrote...
This just uses 1 Min function:

=MIN(12000+0.02*A1,2000+0.04*A1,0.06*A1)

....

Why refer to A1 3 times?

=MIN({12000,2000,0}+{0.02,0.04,0.06}*A1)