Excel Function - How to correctly format this IF AND query

Question

I can't seem to make this IF function work with multiple conditions. Does anybody know how to format this query correctly?

if A1 = "Hat" AND B1 = "1" return "5" if A1 = "Hat" AND B1 = "2" return "10" if A1 = "Glove" AND B1 = "1" return "15" if A1 = "Glove" AND B1 = "2" return "20"

Kuvalya · Accepted Answer · 2016-01-03 11:26:53Z

1

Try this code:

=IF(A1="hat";IF(B1=1;5;IF(B1=2;10;""));IF(A1="glove";IF(B1=1;15;IF(B1=2;20));""))

answered Jan 3, 2016 at 11:26

Kuvalya

1,1161 gold badge15 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Excel Function - How to correctly format this IF AND query

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