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

I have a total $ amount in cell G30. I want a formula in G31 that calculates
a shipping cost as follows: Less than $50 = $10; Greater than $50 Less than
$200 = $15; Greater than $200 Less than $700 = $20. Thanks in advance. rt