IF Function with Multiple Variables

[mminchev]

Hi,

I am trying to create an IF Function that looks at 8 columns of data and if there is a "Y" on any row the functions returns a date.

EXAMPLE:

DATA.

[TABLE="width: 480"]
<colgroup><col width="64" style="width: 48pt;" span="10"> <tbody>[TR]
[TD="width: 64, bgcolor: #2F75B5"]Date[/TD]
[TD="width: 64, bgcolor: yellow"]Days Since Date[/TD]
[TD="width: 64, bgcolor: red"]Extra [/TD]
[TD="width: 64, bgcolor: red"]New[/TD]
[TD="width: 64, bgcolor: red"]Old[/TD]
[TD="width: 64, bgcolor: red"]Super New[/TD]
[TD="width: 64, bgcolor: red"]Not New[/TD]
[TD="width: 64, bgcolor: red"]Super Old[/TD]
[TD="width: 64, bgcolor: red"]Mega New[/TD]
[TD="width: 64, bgcolor: red"]Super
[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]2/15/19[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"]Y[/TD]
[TD="bgcolor: transparent"]Y[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="bgcolor: white"]2/16/19[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]

So the IF Functions is in the yellow row and it looks at each row and if there is a Y anwhere In a row it gives me the days since the Date column.

I tried this: =IF(OR(AND(C3="Y", D3="Y", E3="Y", F3="Y", G3="Y", H3="Y", I3="Y", J3="Y")), TODAY()-A3, "") BUT IT DOESNT WORK

HELP!

 

[Fluff]

How about
=IF(COUNTIF(C3:J3,"Y")>0, TODAY()-A3, "")

 

[Finalfight40]

Try this, just amended yours as i believe you dont need the AND().

=IF(OR(C3="Y", D3="Y", E3="Y", F3="Y", G3="Y", H3="Y", I3="Y", J3="Y"), TODAY()-A3, "")