Swn-Y-Mor

asked on

# Excel Formula IF X equals Y THEN Z

I have two cells that contain If formulae. I would like to compare the two results and then display "passed" in a third cell

CELL W5 Formula =IF(U5>100,"fail","clear")

CELL X5 Formula =IF(V5>0.1,"fail","clear")

I need CELL Y5 to display the word "Passed" if both W5 and X5 both equal "clear"

or if you know an even easier way then suggestions accepted

CELL W5 Formula =IF(U5>100,"fail","clear")

CELL X5 Formula =IF(V5>0.1,"fail","clear")

I need CELL Y5 to display the word "Passed" if both W5 and X5 both equal "clear"

or if you know an even easier way then suggestions accepted

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**