View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default return value based on another value

Hi I am trying to auto insert shipping cost.
What I need to do is have a formula look at order value and return postage
rate as follows if total = <9.49 return 2.90 if total = 9.50 but <19.99
return 6.90 if total =20.00 but < 299.99 return 7.90 if total =300
return 0