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