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

Set add function ignore #N/A 1
Empty cells 1
Excel Add ^ to a row of cells containing letters 3
Flipping Data 4
Output from Frames - multiple optionbutton groups 1
Baffeling IF statement 7
Scrabble Value calculation for Welsh words 0
Finding the Value (of text and numbers) between N/A's 2

Top