Nest if/or formula

raymond.j.riosiii94806

Hi Community, I need your help... I'm trying to create a formula that captures "No Action Taken". The individual IF Statements are as follows:

If [Flu Vaccination Date] is "Blank" OR

If [Flu Vaccination Date] is ">=" [Flu Vaccination Date]$1 OR

If [Flu Declination Date] is "Blank" OR

If [Flu Declination Date] is ">=" [Flu Vaccination Date]$1 THEN

[No Action Taken] = 1

Can you help?

Paul Newcome

Try this...

=IF(OR(ISBLANK([Flu Vaccination Date]@row), [Flu Vaccination Date]@row >= [Flu Vaccination Date]$1, ISBLANK([Flu Declination Date]@row), [Flu Declination Date]@row >= [Flu Vaccination Date]$1), 1)