An If Formula

[Celticshadow]

Hi All

May I ask if the board would be kind enough to help out with an if statement as attached. Thanks in advance.

Kind Regards

https://spreadsheets.google.com/ccc...URfdW1NNFhNUnM1TjUtQ1E&hl=en&authkey=CLLn58QF

 

[VoG]

Try

G2=IF(AND(A2=E1,C2=C1),E2,0)

H2=IF(AND(B2=F1,B2=D1),F2,0)

 

[RSXchin]

vog is faster

 

[Celticshadow]

Try

G2=IF(AND(A2=E1,C2=C1),E2,0)

H2=IF(AND(B2=F1,B2=D1),F2,0)

Hi Vog

Once again that works an absolute treat many many thanks for your help. Top class and at the speed of light.

Kind Regards