Thread: more than one condition for "if"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TrixieA TrixieA is offline
external usenet poster
  
Posts: 2
Default more than one condition for "if"
Can anyone see where I am going wrong? It picks up the first 2 conditions,
but then doesn't get the last 3. I need

1-99 = p5*1.00
100-149, p5*2.50
150-249, p5*2.75
250-300,p5*3
301+, p5*3.25
Reply With QuoteReply With Quote