ExcelBanter - Date depentdant cell additions.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Date depentdant cell additions. (https://www.excelbanter.com/excel-discussion-misc-queries/31923-date-depentdant-cell-additions.html)

Big Rick

Date depentdant cell additions.

I would like a cell to start off at a value of zero. Up to 10 times a year, I
would like to increase this value by one. I have attempted to use the 'IF
(TODAY)' function but can only use this up to seven times. Please Help!!!!
--
Big Rick

Gary's Student

The IF function can only be nested to a certain depth. Look at VLOOKUP to
see if it can help you.
--
Gary's Student

"Big Rick" wrote:

I would like a cell to start off at a value of zero. Up to 10 times a year, I
would like to increase this value by one. I have attempted to use the 'IF
(TODAY)' function but can only use this up to seven times. Please Help!!!!
--
Big Rick

All times are GMT +1. The time now is 07:14 AM.