View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lisa H Lisa H is offline
external usenet poster
 
Posts: 3
Default Conditional Function

I am trying to create a formula that will multiply a portion of a cell by a
percent and the other portion by another percent. For example, when the value
reaches $10,000 I want it to multiply by a different percent. So, if the
value is 20,000 I want to multiply 10,000 by 5% and the other 10,000 by 10%.
Any ideas?