View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Calculation question

On Jul 21, 10:06 pm, "Dana DeLouis" wrote:
Perhaps another option:
=MIN(0.1%*A1+1650, 0.2%*A1+650, 0.3%*A1+150, 0.45%*A1)


Excellent! I would only suggest an explanation of the "magic"
constants. I leave that to you to have the last word on the
subject ;-).