| This is a discussion on Help with an excel formula within the online poker forums, in the General Poker section; If i've put this in the wrong area.......sorry Ill have to show an example of what I want to explain it properly Cell A1 =$100 ... |
| | ||||||
![]() |
| |
|
#1 | ||||
| ||||
| Help with an excel formula If i've put this in the wrong area.......sorry Ill have to show an example of what I want to explain it properly Cell A1 =$100 Cell A2 = $110 My weekly targets run from Tuesdays until Mondays In cell 3 I’m after the following If today is Tuesday then cell 3 = A2-A1 / 7 days On Wednesday it becomes cell 3 = A2-A1 / 6 days And so on until the next week starts where I will continue down B1 & B2 with different values for those weeks. Is there a formula to put in A3 that will subtract A1 from A2 and divide it by the number of days left in the week? If this isn’t that clear please ask me Thanks |
| Play Texas Hold'em Online Poker | Help with an excel formula | |
|
|
|
#2 | ||||
| ||||
| things would have been so much simpler if you used saturdays as your starting point :-/ try this formula: =(A2-A1)/IF(10-MOD(TODAY();7)>7;10-MOD(TODAY();7)-7;10-MOD(TODAY();7)) you would need to format the cell (format menu -> cells -> number tab) with the formula to a number in case anything out of order seems to show up. good luck! -georgi |
Number of Posts: 3
Number of Authors: 3