Using IF and OR function in a formula
I am so close to getting this, but each time I tweak it, I get an UNPARSEABLE message. I am trying to get the Column Titled: Duration (In Hrs) to zero out if EITHER the Not Applicable or Optional rows are checked. The below formula is only making my column 0 out if BOTH the Not Applicable and Optional rows are checked. I'm stumped and I know the answer is right in front of me. Any tips are greatly appreciated!
=IF(OR([Not Applicable]@row = false, (Optional@row = false)), [Duration (In Hrs)]@row, 0)
Help Article Resources
Check out the Formula Handbook template!