Formula Not Showing

[fotodude]

HI Guys,
I have a problem with a formula =IF(AND([@G1]=1,[@Lunch]=1),1,0)
even though G! an Lunch is 1 it still shows me 0
Can that have something to do with the formula what is in Lunch? Because it works just fine in Breakfast and Dinner. Every help is appreciated.
Attached please find my sample file
Thanks,
Martin

[sandy666]

AND() function works like:
AND(1,1) =1
AND(0,1) =0
AND(1,0) =0
AND(0,0) =0
maybe try OR() ?

[FDibbins]

For AND to work, all arguments must be met, not just 1/some

[fotodude]

Thanks for the infos but row 10 to 14 meeting both criteria and it still shows 0 that's why I'm confused.
I need both criteria 1 to show a 1, Or would give me the wrong answer.

The weird thing is if I just put a 1 manually in Lunch column it works.

[Zer0Cool]

Your lunch columns isnt numeric, its text. 1 as a number is not equal to 1 as text.

Convert that column to numbers and it will work

[JohnTopley]

Change H6 to


=IF(AND([@cust]>$C$6,[@cust]<=$C$9),1,0)

Do not put numeric in quotes as they are treated as TEXT so are comparing "1" with 1 (will not match)

=IF(AND([@cust]>$C$6,[@cust]<=$C$9),"1","0")

[Jonmo1]

You have this in the Lunch column

=IF(AND([@cust]>$C$6,[@cust]<=$C$9),"1","0")

"1" is NOT the same as 1
1 is a number
"1" is a TEXT string

Change that formula to
=IF(AND([@cust]>$C$6,[@cust]<=$C$9),1,0)

[fotodude]

Thanks everybody for the help.
JohnTolpey and Jonmo1 suggestion to remove the "" worked.
Thanks again
Martin

[Jonmo1]

You're welcome.