Newbie formula help required pls
 

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.

Newbie formula help required pls
 

You didnt say what your trying to do here!

Simo

--
Message posted from http://www.ExcelForum.com

Newbie formula help required pls
 

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