Thread: Newbie formula help required pls
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luke[_3_] Luke[_3_] is offline
external usenet poster
  
Posts: 2
Default 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.
Reply With QuoteReply With Quote