Newbie formula help required pls

L

Luke

Hi, please can someone help me out with this:

IF A1=12, Then A4=A2:A3 (but)
IF A1=18, Then A4=A2:A3-15% (or)
IF A1=24, Then A4=A2:A3-30% (or)
IF A1=36, Then A4=A2:A3-40%

Thanks in advance.
 
L

Luke

Simon, Thanks for responding however, I have found someone who has sorted me out.
Thanks
 
Top