Forum Discussion
Issues with Excel IF(And) statement
I am attempting to use an IFS statement that when 2 cells equal the criteria, I want it to return the data from another cell. What I've tried so far is: =IFS(AND(B7="A", A9="Buck Openings"), X17...
=IFS(AND(B7="A", A9="Buck Openings"), "X178", AND(B7="Albert", A9="Buck Openings"), "X56",AND(B7="Arabella III", A9="Buck Openings"), "X59", AND(B7="Ashmere", A9="Buck Openings"), "Y65",TRUE, "$0,00")
This works if you want to return texts such as "X178" or "Y65".