I have a formula that works for a master check box and I want to add a condition

Larry Callan

I want the Master check box to put a check in the box on only rows that have the Dept cell filled in.

I have a formula that works for the Master check box. IF the Dept cells are BLANK I don't want the boxes checked.

Thank you in advance,

Larry Callan

Jana Brits

Hey Larry

I believe your formula should be as follows:

=IF(AND($MB$1 = 1, Debt@row <> ""), 1, 0)

Kind regards,

Mark Cronk

Hi Larry,

Try:

=if(NOT(ISBLANK(dept@row)), 1, 0)

Mark

Andrée Starå

Hi @Larry Callan

To add to Mark's excellent advice/answer.

Here's another option.

=IF(Dept@row <> "", 1)

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Larry Callan

Thank you for all the suggestions and they do work for checking if the cell is blank.

I use this formula to check all of the boxes in the column MB when the I check the cell MB1.

=IF($MB$1, 1, 0)

I need to add to the above formula to only allow a check in the box if the cell in the Dept column is Not Blank.

=if(NOT(ISBLANK(dept@row)), 1, 0)    =IF(Dept@row <> "", 1)

I need a way of joining the two.

Thank you

Jana Brits

Hey Larry

I believe your formula should be as follows:

=IF(AND($MB$1 = 1, Debt@row <> ""), 1, 0)

Kind regards,

Larry Callan

Works great!

Thank you

Best Regards,

Larry