IF AND with check box and other criteria
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)
Help Article Resources
Check out the Formula Handbook template!