G
Guest
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(TODAY()<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.
zero.
I have come up with the following formula
=IF(TODAY()<38530,(0),IF(TODAY()<38540,(1),IF(TODAY()<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.