IF AND with check box and other criteria

kim b

I'm sure I'm just missing a comma or something silly that my brain is not catching, but can I get an assist on this one?

Deducted from Purchase Price is a check box column

Accepting Extention? is a text column

I want to add the value from the Amount Due column if the check box is checked and if the cell in Accepting exertion is Yes. I keep getting an #unparseable error message.

=IF(AND([Deducted from Purchase Price]@row = 1, [Accepting Extension?]@row = Yes), [Amount Due]@row,0)

Heather Duff

Hi @Kim Bowie ,

Try putting quotation marks around yes. That should fix it:

=IF(AND([Deducted from Purchase Price]@row = 1, [Accepting Extension?]@row = "Yes"), [Amount Due]@row,0)

Heather Duff

Hi @Kim Bowie ,

Try putting quotation marks around yes. That should fix it:

=IF(AND([Deducted from Purchase Price]@row = 1, [Accepting Extension?]@row = "Yes"), [Amount Due]@row,0)

kim b

I can't believe I missed that. The " " worked. thanks

Heather Duff

@Kim Bowie Sometimes it's the simplest things that trip us up because we're looking for complex problems!