F Function help! I have two cells!!

[rose]

I have two variables, i.e. two cells determine what is displayed... does
anyone know the formula to this...

Would be like "if A2 is = B2 AND if cell C2 = D2 then diplay E2"

=IF(A2=B2&,if(C2=D2,E2))

 

[NBVC]

I have two variables, i.e. two cells determine what is displayed..
does
anyone know the formula to this...

Would be like "if A2 is = B2 AND if cell C2 = D2 then diplay E2"

=IF(A2=B2&,if(C2=D2,E2))

=IF(And(A2=B2,C2=D2),E2,""

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com