Hi,

I'm not going to ask why you would return "Text" if three cells all contain
numbers, but different number.

The formula you want is

=IF(COUNTIF(G1:G12,MAX(G1:G12))=COUNT(G1:G12),MAX( G1:G12),"text")

I continued using the same range as in the previous example.

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"gtb" wrote:

Say A1:A4 are user input cells, start out as blanks. Say user inputs value
4.05 in any three of the cells and leaves the fourth blank. Check if all
values in the 4 cells are the same (not carrying about blanks or location
within the 4 cells). If true return value 4.05 in cell B1, if all values in
A1:A4 are not the same (disregarding blanks) return "Text" in B1????

"gtb" wrote:

How would you check all values in a column, real numbers, to see if they are
all the same or if any differ. Not counting blanks?