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
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
Can you complete the requirement ?
IF a specified cell = 1, then do what?
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
=if(x4 = 1, --or(i4 = 0, j4 = 0, x4 = 1), "???")
Entia non sunt multiplicanda sine necessitate
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'
Perhaps
O20: =IF(N20=1,IF(OR(K4=0,L4=0),0,1),"N20<>1")
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
You didn't indicate what should happen if N20 is NOT equal to 1, so I just put in a placeholder "N20<>1"
sorry
N20 is the start of the column in running the formula down - so above are cells n20, n21, n22, n23 etc etc
so do I need to remove the place holder for it to work?
Thanks
I want a 0 indicated if not equal to 1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks