Help with an excel formula

#1 1st April 2008, 11:04 AM

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

#2 1st April 2008, 11:38 AM

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

#3 1st April 2008, 11:39 AM

(A2-A1)/input either 7,6,5,4,3,2,1

That should work if not, reply with more info about what you are trying to actually accomplish, because their are plenty of already made spreadsheets.

Play Texas Hold'em Online Poker \| Help with an excel formula
BetOnline Poker is a top online poker site accepting all US players with an INSTANT cash bonus of up to $900 FREE. It also has a casino and sports betting available.	PokerStars is one of the best places to play poker online. Use PokerStars marketing code CCHAT for a $600 bonus. Note: No US Players Accepted.