ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Reaching Max (https://www.excelbanter.com/excel-discussion-misc-queries/190072-reaching-max.html)

SilviaG

Reaching Max
 
I have a spreadsheet that is tracking vacation time.
It looks something like this
A B C D E
1 5 6 7 8 9

A1: 5
B1: 1+A1

Is there a formula that i can use that once it has reached a maximum amount,
lets say ten, it will stop counting



All times are GMT +1. The time now is 06:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com