Help with an IF OR function
Hi,
I am trying to write a formula that says that the status indicator in a column should turn red if either a) answer in drop down column is "No," or b) second column is NOT left blank (i.e., if someone adds information to the column). I have been able to get formulas for either of the two functions to work independently with just the IF fxn, but as soon as I try to string the two together with IF (OR..., I get either Unparseable error or Incorrect argument error. I think I must be off by a parenthesis or bracket or something. Any help would be appreciated!
Here's the formula I am using. Each argument as written works if used independently:
=IF(OR([Reviewed MD Agrees with Final Category]@row = "No", NOT(ISBLANK([Response by Reviewed Physician@row])), "Red"))
Best Answer

It worked! Thank you!!
Answers

You just have a misplaced parenthesis...
=IF(OR([Reviewed MD Agrees with Final Category]@row = "No", NOT(ISBLANK([Response by Reviewed Physician@row]))), "Red")

Hi Paul!
Thanks for the response. I pasted the above and it's still giving me an unparseable error :(

I had just copy/pasted to move things around and din't notice that there is a square bracket out of place. Try this one...
=IF(OR([Reviewed MD Agrees with Final Category]@row = "No", NOT(ISBLANK([Response by Reviewed Physician]@row))), "Red")

It worked! Thank you!!

Help Article Resources
Categories
Check out the Formula Handbook template!