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