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

Why don't you using Visual Basic Editor.
Visual Basic Editor has the function of "Select Case".



AndyS wrote:
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

Andy

If you only have a few (less than 7 criteria) then you could nest IFs. In A5
enter

=IF(A1=5,9,IF(A1=7,12,15))

If there are many then set up a table in another sheet with the two columns
showing the original data and next to it the desired result. Then use a
VLOOKUP on this data, e.g

=VLOOKUP(A1,Sheet2!$A$1:$B$25,2,FALSE)

Where A1:B25 on sheet2 is where your lookup table is

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

"AndyS" wrote in message
...
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

See response in worksheet.functions


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"AndyS" wrote in message
...
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