Help with cell function;456453 Wrote:
if cell e 14 = y and cell g14 is less than 15, h14 should be y...how do
i do
it? ThanksPut this forumula in H14
=IF(AND(E14=y,G14<15),E14,"False")
You didn't state what should be shown if the statement wasn't true but
just chage "False" to whatever you want.
--
Simon Lloyd
Regards,
Simon Lloyd
'Microsoft Office Help' (
http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.thecodecage.com/forumz/member.php?userid=1
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=126337