View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joaniemic joaniemic is offline
external usenet poster
 
Posts: 14
Default Discount % Between 2 Dates

I am trying to have a 5% discount appear if an order is placed between (and
including) two dates...
If C41 is between (and including) 11/10/2008 and 01/02/2009 and E30 is equal
to or greater than $600, B32 is 5%, otherwise B32 is at 0%.