Addition with strange condition

[SEMME]

Hi,

Formula in cell A2 is a simple (=A1+1), so that where:

content of cell A1 is 98
cell A2 would add 1 and show 99

content of cell A1 is 99
cell A2 would add 1 and show 100

However where content of cell A1 surpasses 100:

I DO NOT wish A2 to add 1 but instead to continue to display 100.

Where cell A1 is 99 or less cell A2 will add 1 as normal, upto
a maximum of 100.

If what I'm after is not clear, I apologise and will elaborate.
Thanks for your assistance.
SEMME

 

[Von Pookie]

Maybe something like this?

=IF(A1+1>=100,100,A1+1)

 

[Juan Pablo González]

Or

=MIN(100, A1+1)

 

[lenze]

OR
=MIN(A1+1,100)

Edit; **** , I'm slow Juan

 

[Mark W.]

=MIN(A1+1,100)

 

[SEMME]

Thanks Again for your support,

The MIN function worked well for my purpose.

SEMME