Thread: If Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trying To Excel Trying To Excel is offline
external usenet poster
  
Posts: 13
Default If Function
A B
1-5 $ 200.00
6-10 $400.00
11-15 $ 600.00
16-20 $ 750.00
21-30 $ 1000.00

Question - If the value in a cell in Column A falls within a specified range
then the corresponding $ amount is in Column B.
Reply With QuoteReply With Quote