New Formula (Burt)
Sorry, fairly new to this.
"Joe User" wrote:
See response to your other thread ("Additional formula"). Please do not post
multiple messages for the same question.
----- original message -----
"Help with cell function" wrote:
That worked Judith. How about this, I only want this to work if an N shows up
in L6 not a Y. Thanks
"JudithJubilee" wrote:
Hi,
Try this:
=IF(x6="x","C",if(AND(H6="x",K6<=14),"Y",IF(AND(H6 ="x",K6=15),"N")))
--
Hope this helps
"Help with cell function" wrote:
This is a formula that I have in my spresdsheet at L6 to answer Y or N to
certain criteria. I need additional criteria added. I need the same formula
but if there is an x in cell "X6" I need the answer to be C in L6 instead of
Y or N.
=IF(AND(H6="x",K6<=14),"Y",IF(AND(H6="x",K6=15)," N"))
|