View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jackiec21 Jackiec21 is offline
external usenet poster
 
Posts: 3
Default IF then statements-Tiered PRicing

Please help!

I am going to have to create an Excel spread using tiered pricing. I
imagine it will be:

IF QUANTITY PRICE
<100 10.00
100 5.00


Please help-I have no idea how to use an "IF" statement to make this work
and this is what my boss wants. Thanks!