Formula Needed Numerical and text conditions

[ItalianPlatinum]

Hello - I am looking for a formula that will show me NO CHANGE if all 3 conditions are met, and if one isnt then it is checking if that figure matches back if it does then says match if doesnt it says doesnt match. for example the below:

Activity	TMV	Condtion 1	Condition 2	Condition 3	Total MV	New MV	CHECK (FORMULA NEEDED)
Y	100	No change	No change	50	50	50	MATCH
N	500	No change	No change	No change	No change	No change	No change
Y	900	700	No change	No change	700	700	MATCH
N	1000	No change	No change	No change	No change	No change	No change
Y	0	No change	0	No change	0	0	MATCH
Y	900	600	No change	No change	600	700	Doesn't MATCH

Formula for Match or doesnt match: Total MV = New MV

 

[Fluff]

How about

=IF(COUNTIFS(C2:E2,"No change")=3,"No change",IF(F2=G2,"Match", "No match"))