Using IF AND statement in Excel formula doesn't work

Question

Hello All,

I've alter question in simpler way.

Right now I'm working on image where Col A & B has some values. I've to find values in Col C, where if Col A values "No Windows" & Col B values "No SQL".

I've used formula of IF AND statement in Col C. The Col C will represent it as "Yes" where Col A values "No Windows" & Col B values "No SQL" else formula will reflect it as "no".

For reference: In Col D represent the actual result needed after formula is applied.

Formula used : IF AND statement in Excel

=IF(AND(A2="No Windows",B2="No SQL"),"Yes","no")

Not sure what you're asking. Do you mean if "No Windows" is in column A and something other than "No SQL" is in column B you want to delete the entries, or copy them somewhere and then delete? — SJR
– SJR, Commented Apr 21, 2020 at 18:53
Have you checked to see if there are leading or trailing spaces? Try trim(a2) and trim(b2) in the and()... — Solar Mike
– Solar Mike, Commented Apr 22, 2020 at 4:18

Solar Mike · Accepted Answer · 2020-04-22 04:38:07Z

2

So sometimes the data tested has leading or trailing spaces, try using trim() like this:

=IF(AND(trim(A2)="No Windows",trim(B2)="No SQL"),"Yes","no")

answered Apr 22, 2020 at 4:38

Solar Mike

8,4255 gold badges23 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using IF AND statement in Excel formula doesn't work

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related