F Function help! I have two cells!!
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)) |
F Function help! I have two cells!!
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 |
All times are GMT +1. The time now is 10:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com