keep getting syntax error with IF & AND statement

The function is fine here. Was this just an example? I ask because I don't know why you put TRUE and FALSE in quotes, unless they are standing in for something else or you needed them to be text. If TRUE/FALSE are the desired results, a simpler formula is =AND(B3>5.6, B3<6.6).

But back to the problem: If your function is giving you a syntax error, one common reason is regional. If your computer is set to a region that uses a comma as a decimal separator, the parameters in functions are separated by semicolons, not commas. And if this is the case for you, 5.6 and 6.6 would need to be 5,6 and 6,6.

=IF(AND(B3>5,6; B3<6,6); TRUE; FALSE)

If that is not it, did you copy/paste the exact formula from your spreadsheet to your post or did you retype it? If retyped, maybe you fixed the problem when you typed it in here.

Hi Craig,

It looks like you are using Numbers > Settings > General > Cell References: > Use header names as labels.

The formula that you pasted in your reply contains smart quotes:

IF(AND(Reading '6/24/2023 12:47 PM'>5.6,Reading '6/24/2023 12:47 PM'<6.6)”Acidic”,”N/A”)

Formula in C2:

IF(AND(Reading '24 Jun 2023 12:00 am'>5.6,Reading '24 Jun 2023 12:00 am'<6.6),"Acidic","N/A")

Regards,

Ian.

I copy/pasted your formula from your post to a spreadsheet and it worked correctly. That is why I asked if you had copy/pasted it from your spreadsheet to your post vs retyping it. If you retyped it here, copy/paste it from your post to your spreadsheet and that might fix it.

Yes. After the <6.6) you need a comma