=IF(OR formula - Applying this to whole row not one cell

[STB10]

Hi I have a formula of =IF(OR(E7="A", E7="AS"), "Unavailable", "Available"). I want this to apply to the whole row and not just cell E7.
Any ideas.

available? JOB 1 JOB 2 JOB 3 JOB 4 JOB 5 JOB 6 JOB 7 JOB 8 JOB 9 JOB 10 JOB 11 JOB 12
Person 1 Unavailable AS c
Person 2 Available C
Person 3 Available A
Person 4 Available C
Person 5 Available AS
Person 6 Available
Person 7 Available
Person 8 Available

[PaulM100]

I am not sure what you want but if the formula should apply to the entire row based on the info in column E, then hardcode it and drag it:

=IF(OR($E7="A", $E7="AS"), "Unavailable", "Available")

[STB10]

It's not as simple as hardcoding. I want to look through the whole row and if in that row there is an A or an AS then I want the result to be 'unavailable. If there is only 'C' (for complete) or blanks then I want 'Available'

I tried this but it didn't work:
=IF(OR(E7:P7="A", E7:P7="AS"), "Unavailable", "Available").

[PaulM100]

Iit would help if, rather than having another lengthy desciption, you show us what you want to see in an Excel sheet.

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).


Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Upload it.

[AliGW]

Try this (untested):

=IF(OR(IFNA(MATCH("A",E7:P7,0),0)>0,IFNA(MATCH("AS",E7:P7,0)>0), "Unavailable", "Available")

[STB10]

Brill. thanks.

[STB10]

Missing some ). When rectified Error is #NAME?

Try this (untested):

=IF(OR(IFNA(MATCH("A",E7:P7,0),0)>0,IFNA(MATCH("AS",E7:P7,0)>0), "Unavailable", "Available")

[AliGW]

Try this:

=IF(OR(IFERROR(MATCH("A",E7:P7,0),0)>0,IFERROR(MATCH("AS",E7:P7,0),0)>0), "Unavailable", "Available")

[STB10]

You're an absolute star!!

[AliGW]

Glad to have helped!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.