Excel question

[thunderstruck]

Quick excel question. I have the following in an excel sheet:

[pic]http://img123.imageshack.us/img123/2483/excel5oq.jpg[/pic]

I need a formula in cell B2 that checks the value of cell B3 and cell K3. If the value in either of these cells is "1" then cell B2 goes blank.

Hope this makes sense....thanks.

[TangoAlpha]

How about...

=IF(B3 = 1, "", IF(K3 = 1, "", COLUMN(B2) - 1))

[TheGroover]

thunderstruck said:

Quick excel question. I have the following in an excel sheet: I need a formula in cell B2 that checks the value of cell B3 and cell K3. If the value in either of these cells is "1" then cell B2 goes blank. Hope this makes sense....thanks.

Try =IF(OR(B3=1,K3=1),"",1)

[thunderstruck]

Perfect - many thanks