Largest number in column and conditional

[SunValley]

I've been trying to combine IF and LARGE but I'm not getting the formula right.
=IF(A2=LARGE(A2:A22;1);"X";"Y")

If the A2 cell has the first largest number before the first dot in column A, name "X" is returned, if not, return "Y".
For example: if column A contains in each cell, 5.0, 5.1, 5.2, 3.0, 2.0, 1.0 , then it means that 5.0, 5.1 and 5.2 will be considered as "First largest number".

Although 5.3 is greater than 5.1 and 5.0, only what is before the dot is important, so both 5.3, 5.1, and 5.0 would return "X" because they are the first largest number in the column before the first dot.

 

[GuzmanServices]

Without seeing your data, I would begin by adding $ to the Row indicators for the LARGE function.
Also try to replace the semi-colons with commas, if necessary.

=IF(A2=LARGE(A$2:A$22;1),"X","Y")

 

[SunValley]

I used the formula you provided, but it's giving an error

 

[SunValley]

Without seeing your data, I would begin by adding $ to the Row indicators for the LARGE function.
Also try to replace the semi-colons with commas, if necessary.

=IF(A2=LARGE(A$2:A$22;1),"X","Y")

The formula I provided was correct, but for some reason it was resulting in an error.
=IF(A2=LARGE(A2:A22;2);"X";"Y")

However, it doesn't recognize the cells as a number if I use information like "1.0" instead of "1",
the formula doesn't work. Excel doesn't seem to recognize numbers if they're followed by a dot. I don't know where to fix it.

 

[Peter_SSs]

Duplicate to: Formula does not work if it refers to a cell that contains a number that is the result of a formula

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread since the other one now has a marked solution.