If and statements

efleming

I would like to create a formula that will check the “MISSED” box if the “# OF VISITS LW” is less than the “Tx PLAN” number. But I would like to have the “# OF VISITS TW” supersede the prior. For example, If the “# OF VISITS TW” is equal to or greater than the “Tx PLAN” number, the checkbox would be unchecked or if the “# OF VISITS TW” is less than “Tx PLAN”, it remains checked.

 

Julie Fortney

Hi! Try this formula:

=IF([# OF VISITS TW]@row >= [Tx PLAN]@row, false, IF([# OF VISITS TW]@row < [Tx PLAN]@row, true, IF([# OF VISITS LW]@row < [Tx PLAN]@row, true)))

Julie Fortney

Hi! Try this formula:

=IF([# OF VISITS TW]@row >= [Tx PLAN]@row, false, IF([# OF VISITS TW]@row < [Tx PLAN]@row, true, IF([# OF VISITS LW]@row < [Tx PLAN]@row, true)))

efleming

Thank you Julie! That was perfect.

efleming

The formula needs to be altered where if the patient is checked for Troubled there should not be a check for Missed. I tried changing the formula but it did not work.

=IF([# OF VISITS TW]@row >= [Tx PLAN]@row, false, IF([# OF VISITS TW]@row < [Tx PLAN]@row, true, IF([# OF VISITS LW]@row < [Tx PLAN]@row, true)))

Genevieve P.

Hi @efleming

You can add another IF statement to your formula, but make sure this is the first one for it to look at:

=IF([TROUB.]@row = 1, 0,

So something like:

=IF([TROUB.]@row = 1, 0, IF([# OF VISITS TW]@row >= [Tx PLAN]@row, false, IF([# OF VISITS TW]@row < [Tx PLAN]@row, true, IF([# OF VISITS LW]@row < [Tx PLAN]@row, true))))

Cheers,

Genevieve