Multiple cells referred to in IF formula query

Hi there,

I'm trying to set up a formula that refers to 3 other cells, to display "1" where if one of the other cells (A4, B4, C4) shows "1".

I've tried this:

=IF(OR(A4=1,B4=1,C4=1), "1", "")

but nothing doing!?

Not sure if this has anything to do with it, but the contents of cells A4, B4, C4 are all as a result of single IF formulas.

Help please!

Try this:

=IF(OR(A4=1,B4=1,C4=1), 1, "")

since the 1 is a numerical not a text value it doesn't need quotes.

Tried your suggestion but still showing "0" - is this because the cells it's referring back to dont have 'content' but the result of a formula (A4, B4, C4 all have a simple =IF(Z4=Y4,1,0)?

Are those formulas showing

=IF(Z4=Y4,1,0)

or

=IF(Z4=Y4,"1",0)

Make sure it's the former and your formula should work

Originally Posted by daddylonglegs

Are those formulas showing

=IF(Z4=Y4,1,0)

or

=IF(Z4=Y4,"1",0)

Make sure it's the former and your formula should work

FANTASTIC! Removing the ""'s has sorted this out!

Many many thanks - this has been driving me and a few colleagues mental for the past few days!

Cheers!