Forumula to return value if cells in range are the same

[Jamidd123]

A1	A2	A3	A4
EL1	EL1	EL1	EL1

<tbody>
</tbody>

Hi Mrexcel Forum,

I am trying to work out a formula that looks in a range to see if all cells in that range are the same and if they are then I would like the formula to return the value that is the in the range.

Example:
Please see table above I would like the formula in A4 and the range to be A1 to A3. (for some reason I could not get the table at the bottom of my post!!)

Thank you in advance

Jamidd

 

[Fluff]

Hi & welcome to MrExcel.
How about
=IF(COUNTIF(A1:A3,A1)=3,A1,"")

 

[Jamidd123]

Thank you for your quick response!
That works treat! I managed to get to the point where it would say TRUE! Your a DIAMOND!

Would there be anyway to add if value is say x across all three then leave blank?

Thank you again!

 

[Fluff]

How about
=IF(COUNTIF(A1:A3,"x")=3,"",IF(COUNTIF(A1:A3,A1)=3,TRUE))
Change the "x" to whatever value you want