View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Boze
 
Posts: n/a
Default my first 'IF' formula

I've never done anything beyond the most basic formula. Can someone tell me
where to begin for a formula for our pricing? We have our cost and want to
use different formulas based on the cost
If the cost is 99¢ or less we take the cost * 1.14 then divide by .75
If the cost $1 to $1.99 we take the cost * 1.14 then divide by .78
This would continue for $2 to $2.99, $3 to $3.99, etc

Thanks in advance
Boze