| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
| Need to use IF formula with a Date cell | Excel Worksheet Functions | |||
| Making a auto date entered into a cell permanent from a template | Excel Discussion (Misc queries) | |||
| Return a date 6 months from a date in another cell | Excel Worksheet Functions | |||
| cell assumes wrong date | Setting up and Configuration of Excel | |||
Linear Mode
