Trying to get a box to check

Craig Lemberger

Good Day,

I am trying to get a box in a column to check if two conditions are met:

1. If one cell is not blank and the other is blank. I can't get it to work.

=IF(AND(NOT(ISBLANK([Captain Jack's]@row, ISBLANK([Quantity (Captain Jack's)]@row), 0, 1), 0))

Ray Lindstrom

Hi @Craig Lemberger,

Try this: =IF(AND(NOT(ISBLANK([Captain Jack's]@row)), ISBLANK([Quantity (Captain Jack's)]@row)), 1, "")

Best of luck to you!

BRgds,

-Ray

Craig Lemberger

It worked!!! Thank you so very much @Ray Lindstrom

Ray Lindstrom

Hi @Craig Lemberger,

Try this: =IF(AND(NOT(ISBLANK([Captain Jack's]@row)), ISBLANK([Quantity (Captain Jack's)]@row)), 1, "")

Best of luck to you!

BRgds,

-Ray

LMC

I am search of the same type of help. Should the formula contain an COUNTIFS?

Craig Lemberger

It worked!!! Thank you so very much @Ray Lindstrom

Ray Lindstrom

@LMC,

No countifs for this particular situation.

Craig Lemberger

@Ray Lindstrom Thanks again. I am now trying to get the box to check dependent on two separate scenarios. The one you helped me with above plus another.

=IF(OR(AND(NOT(ISBLANK([Captain Jack's]@row)), ISBLANK([Quantity (Captain Jack's)]@row)), IF(AND(NOT(ISBLANK([Quantity (Captain Jack's)]@row)), ISBLANK([Captain Jack's]@row)), 1, "")))

I tried all different ways but still not working. Do you see anything right away that is wrong?