View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MINI MART
 
Posts: n/a
Default writing a greater than/less than formula



"BobVA" wrote:

Hello,

I'm ok in Excel but I need to write a formula to calculate that if sales are
greater than 100,000 but less than 200,000 multiply that number by 25%.
Probably real easy for some of you but I can't quite get it to work. Any
suggestion is welcome.