using with If() And(), have to solve dont know why its is showing error AND must be true output but showing false

[mklearn]

may be in text its 'Female not Female, this ' symbol is getting into error.
file is also attached

 

[Debaser]

AND operates on all the cells in the range passed to it and returns one result, not an array. Use:

=IF(AND($E11="Female",$H11<50000),"Eligible for gift","0")

and copy it down.

 

[mklearn]

t

AND operates on all the cells in the range passed to it and returns one result, not an array. Use:

=IF(AND($E11="Female",$H11<50000),"Eligible for gift","0")

and copy it down.

thank you so much its done