I'm trying to come up with a formula that gives TRUE if the reference cells have 0 or 90 as the value. I tried
=IF(OR(CSV!Z5=0,CSV!Z5=90,CSV!AA5=0,CSV!AA5=90),TRUE,FALSE)
but it doesn't seem to be working - or at least it's not giving me the results I need. Basically, I want it to tell me
IF CSV!Z5=0 then TRUE or
IF CSV!Z5=90 then TRUE or
IF CSV!AA5=0 then TRUE or
IF CSV!AA5=90 then TRUE
Also
IF CSV!Z5 is TRUE and CSV!AA5 is FALSE then FALSE
IF CSV!Z5 if FALSE and CSV!AA5 is TRUE then FALSE
Any help is appreciated. Thank you!
=IF(OR(CSV!Z5=0,CSV!Z5=90,CSV!AA5=0,CSV!AA5=90),TRUE,FALSE)
but it doesn't seem to be working - or at least it's not giving me the results I need. Basically, I want it to tell me
IF CSV!Z5=0 then TRUE or
IF CSV!Z5=90 then TRUE or
IF CSV!AA5=0 then TRUE or
IF CSV!AA5=90 then TRUE
Also
IF CSV!Z5 is TRUE and CSV!AA5 is FALSE then FALSE
IF CSV!Z5 if FALSE and CSV!AA5 is TRUE then FALSE
Any help is appreciated. Thank you!