rose;453434 Wrote:
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,"")


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125521