Hey guys, I am trying to build a matrix model where the variable of a cell ( e.g C5=5 ) will increase to 6 with each increment in date number. I have tried the following formula but it doesn't seem to work. Any help on this matter is greatly appreciated.cell row.PNG
Last edited by elyas91; 01-27-2021 at 08:25 AM.
may be the following
=if(I8>I7,H7+1,H7)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Hey there!
Ermmm, I don't think that is what I am looking for, mate. What I intended is for cell J7 to increase with each addition in cell I7. As cell I7 is a reference to today's date and would therefore increase automatically tomorrow, that means the cell J7 would also increase by 1 every single day... :-) Because I want my probability of failure to increase gradually as a function of time . ..
Then you will need a static date, like =if(I7>1/27/2021,H7+TODAY()-1/27/2021,H7)
Click the * to say thanks.
Dear Paul,
Beautiful answer!!! Amazing solution.. Thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks