Can another IF be added to this =IF(OR(I4=0,J4=0),0,1)

[paulr0700282]

so this formula does what I need =IF(OR(I4=0,J4=0),0,1)

however - if need another IF - so I need this formula to run IF a specified cell = 1

[Jonmo1]

Can you complete the requirement ?

IF a specified cell = 1, then do what?

[paulr0700282]

so IF column H returns the value from the stated formula - the the following formula runs =IF(OR(K4=0,L4=0),0,1)

So I need a second ''IF" ........ if you get my drift lol

[shg]

=if(x4 = 1, --or(i4 = 0, j4 = 0, x4 = 1), "???")

[paulr0700282]

sorry I not explaining it properly

cell N20 has the following formula =IF(OR(I4=0,J4=0),0,1)
so when I4 & J4 both don't equal 0 a value of 1 is presented
I need the adjacent column 'O' to have a formula which runs when the 1 is presented in 'N'
That's formula I need is =IF(OR(K4=0,L4=0),0,1)

I just don't know how make the formula run if the number 1 is presented in the adjacent column 'N'

[Jonmo1]

Perhaps

O20: =IF(N20=1,IF(OR(K4=0,L4=0),0,1),"N20<>1")

[paulr0700282]

Ok , almost - this is what was returned (below) the '1's and '0's work as intended but the 'N20<>1's do not

N20<>1
0
1
0
0
1
0
1
N20<>1
N20<>1
1
N20<>1

[Jonmo1]

You didn't indicate what should happen if N20 is NOT equal to 1, so I just put in a placeholder "N20<>1"

[paulr0700282]

sorry

N20 is the start of the column in running the formula down - so above are cells n20, n21, n22, n23 etc etc

[paulr0700282]

so do I need to remove the place holder for it to work?

Thanks

[paulr0700282]

I want a 0 indicated if not equal to 1