Hi,
I trying to display depending on values from Main cell (cell C) nested with Multiples cell, so far a i have good result but i still need to add a criteria on more cells with some values.
i made a short formula that is working :
But to existing formula i need to add multiples different values of Cell D and E to get a correct display :
Example : If
C4 have One of these Value-> 000, 001, 002, 010, 011
and
D4 have --> 1
and
E4 have --> 1
and
F4 have --> 3
then Display -> "Stay" if FALSE then "AWAY"
Then at same Formula i need to add last part of the formula for Cell D4, E4 and F4 with different values, example
Cell (D4 have --> 2, E4 have --> 1, F4 have --> 2 )
Within the same formula but with out adding the Long formula applied to C4
(can i do that?)
Thank you very much for any help (or link suggestion)
I trying to display depending on values from Main cell (cell C) nested with Multiples cell, so far a i have good result but i still need to add a criteria on more cells with some values.
i made a short formula that is working :
Code:
=IF(AND(OR(C4="000",C4="001",C4="002",C4="010",C4="011"),D4="1",E4="0"),"Stay","AWAY")
But to existing formula i need to add multiples different values of Cell D and E to get a correct display :
Example : If
C4 have One of these Value-> 000, 001, 002, 010, 011
and
D4 have --> 1
and
E4 have --> 1
and
F4 have --> 3
then Display -> "Stay" if FALSE then "AWAY"
Then at same Formula i need to add last part of the formula for Cell D4, E4 and F4 with different values, example
Cell (D4 have --> 2, E4 have --> 1, F4 have --> 2 )
Within the same formula but with out adding the Long formula applied to C4
(can i do that?)
Thank you very much for any help (or link suggestion)
Last edited: