I'm new at understanding Excel functions and formulas, and have looked around for an answer to this question, including reading through many of Excel's functions such as ISBLANK or VLOOKUP. Apparently I don't know what I don't know when it comes to the syntax for the particular problem I'm facing:

I have a spreadsheet that has a primary column with a number of major points (in this case designated by 1,2,3…200+) interspersed with a series of minor points (1.1, 1.2, 1.3,etc). The variability of the minor points is unknown, as the minor points could be as high as 99 but as low as 1 (e.g., 1.1 to 1.99 or anywhere in between).

I can't figure out how to draft a formula report back at which cell the next major point occurs (e.g., where 1 becomes 2, or said a different way when the minor points after 1 go higher than 1.99 ). The reason I'm looking for a formula that will return the cell location (e.g., A31) is to use it be able to apply another, separate formula in a row for each of the minor points.

In any event, I don't want a 200-input nested if/then statement if the major points rise to the level of 200 whole numbers

Thanks in advance for any insight into how I can attack this particular formula with one or several functions.