Smartening up an IF formula

S

Stav19

Hi All

I've the following IF formula which looks in Columns A:F and based on
what is in the Cell - "Yes" or "N/A", it will write "Yes" if "Yes" or
"N/A" is written in the cell and "O/S" if the row is empty:

=IF(OR(A1="Yes",B1="Yes",C1="Yes",D1="Yes",E1="Yes",F1="Yes"),"Yes",IF
(OR(A1="N/A",B1="N/A",C1="N/A",D1="N/A",E1="N/A",F1="N/A"),"Yes","O/
S"))

My questions are as follows:

I think this works, but it seems quite a long winded way of doing it,
is there a way of simplifying it?

From testing it, it seemed to work if the row was completely empty, is
there a way to corporate the blank into the formula, or is it best to
leave it as it is?

Cheers in advance guys
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
VBA Coding Help for Beginner 0
Find #N/A in column D 2
match some character in b1 to c1 and display on d1 3
Cell value that changes previously entered value 9
If, Or, and 5
Copy addition formula of non-consecutive horizontal cells 2
Sum Function When Formula Produces #N/A 2

Top