This is a discussion on Addition with strange condition within the Excel Questions forums, part of the Question Forums category; Hi, Formula in cell A2 is a simple (=A1+1), so that where: content of cell A1 is 98 cell A2 ...

1. ## Addition with strange condition

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.
SEMME

2. ## Re: Addition with strange condition

Maybe something like this?

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

3. ## Re: Addition with strange condition

Or

=MIN(100, A1+1)

4. ## Re: Addition with strange condition

OR
=MIN(A1+1,100)

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

5. ## Re: Addition with strange condition

=MIN(A1+1,100)

6. ## Re: Addition with strange condition

The MIN function worked well for my purpose.

SEMME

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•