Thread: If statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TamIam TamIam is offline
external usenet poster
 
Posts: 29
Default If statement

Help!! I need a formula that will display the number of credits earned (1
per $500 of sales) in increments of $500 with a minimum purchase of
$500...for example, $750 worth of sales = 1 credit, $1000 sales = 2 credits
and so on...
--
Thanks for your help!