theatreking
New Member
- Joined
- May 1, 2014
- Messages
- 9
Hi,
Was hoping to get a little help in getting this formula correct.
I can get it to work when entering this - =IF(AND(P5<J5,(J5/2)<O5),"G","R")
But as soon as I add another - =IF(AND(J4>100,"Y"),P4<J4,(J4/2)<O4),"G","R") I get an error.
Do I have it the wrong way around or do I have to use a OR statement?
Cheers!
Was hoping to get a little help in getting this formula correct.
I can get it to work when entering this - =IF(AND(P5<J5,(J5/2)<O5),"G","R")
But as soon as I add another - =IF(AND(J4>100,"Y"),P4<J4,(J4/2)<O4),"G","R") I get an error.
Do I have it the wrong way around or do I have to use a OR statement?
Cheers!
Last edited: