| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date dependant values.
Up to 10 times a year, I want to add a value of one to cell V4 starting with
zero. I have come up with the following formula. =IF(TODAY()<38530,(0),IF(TODAY()<38540,(1),IF(TODA Y()<38550,(2),IF(TODAY()<38560,(3),4)))) etc. The problem is that I can only use the IF formula seven times. I would very much appreciate it if you could write a new formula for me as I am quite new to the whole thing and it took me weeks to work mine out! (I have been advised to use the VLOOKUP formula but cannot get my head round it.) Thanking you in anticipation. -- Big Rick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Sum range of values that meet date criteria | Excel Discussion (Misc queries) | |||
| Grabbing recods based on date and shift values | Excel Worksheet Functions | |||
| Adding values for prior date intervals | Excel Worksheet Functions | |||
| Counting values within a Date Range | Excel Discussion (Misc queries) | |||
Threaded Mode
