Forumula to return value if cells in range are the same

[Jamidd123]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A1
[/TD]
[TD]A2
[/TD]
[TD]A3
[/TD]
[TD]A4
[/TD]
[/TR]
[TR]
[TD]EL1
[/TD]
[TD]EL1
[/TD]
[TD]EL1
[/TD]
[TD]EL1
[/TD]
[/TR]
</tbody>[/TABLE]
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