Thread: help creating a formula using IF and AND
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default help creating a formula using IF and AND
=IF(AND(A2A1,A4A3,SUM(A10A9,A8A7,A6A5)=2),A2* 0.03)

--
HTH

RP
wrote in message
oups.com...
Thanks Dave, wasn't sure if I was in the right forum. I've got another
tough one for you:

If A2A1 AND A4A3 AND 2 out of the next 3 need to be true A10A9,
A8A7, A6A5 Then A2*.03 or FALSE



Reply With QuoteReply With Quote