Function IF AND OR (main Value cell) nested to multiples cells to get exact Result

[AndyJR]

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 :

=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)

 

[AndyJR]

Hi snjpverma,

Your formula work perfect and is shorter.

But Question:

How do i put together the same formula twice (up to 7 times) on same cell?
The second formula will be with different values on Cell C,D,E and F, and with the Text "Run" "walk"

I Put the formula and at the end i Add + (plus sign) and added the second formula (with out the =) and it display an #VALUE error (a value used in the formula is of the wrong data type)


Thanks again!!

 

[AndyJR]

Hi

[SOLVED] Question on Post #11

After first long formula Added an ampersand "&" then added the second formula

Thank you!!!!!