Thread: multiple response
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AndyS AndyS is offline
external usenet poster
  
Posts: 3
Default multiple response
I need to get different responses depending on a given quantity. Like a
mutiple IF fomula ie

If A1=5 then A5= $9
If A1=7 then A5 =$12
IFA1=12 then A5=$15
Any Ideas would be much appreciated
Reply With QuoteReply With Quote