Hey, I have excel 2000 and here's what i'm making and what my problem
is:

basically, i'm trying to collect a certain amount of money in a certain
amount of time :) and i'd like to make it so it calculates how much i've
gotten from day 1 and figures out how many more days it will take for me
to reach my goal...
hope you can get that.

in short, what i need is a countdown function like
=today()+(amount of days it will take with the average money made per
day)
...or kind of like that.

can anyone help me?


--
simserob
------------------------------------------------------------------------
simserob's Profile: http://www.excelforum.com/member.php...o&userid=36635
View this thread: http://www.excelforum.com/showthread...hreadid=563830

simserob Wrote:
Hey, I have excel 2000 and here's what i'm making and what my problem
is:

basically, i'm trying to collect a certain amount of money in a certain
amount of time :) and i'd like to make it so it calculates how much i've
gotten from day 1 and figures out how many more days it will take for me
to reach my goal...
hope you can get that.

in short, what i need is a countdown function like
=today()+(amount of days it will take with the average money made per
day)
...or kind of like that.

can anyone help me?

Try = today()+CEILING(AmountNeeded/AverageAmountPerDay)

Where AmountNeeded and AverageAmountPerDay are references to whereever
you have them.

Scott


--
Maistrye
------------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078
View this thread: http://www.excelforum.com/showthread...hreadid=563830

when i do that it says there's an error - i guess it doesn't recognize
the significance of the numbers...i also would need a day counter to
get the average amount earned per day.
i think with the formula you gave me, it wouldn't come out to an amount
of days...i'm not really sure though since i've never heard of the
command "ceiling"


--
simserob
------------------------------------------------------------------------
simserob's Profile: http://www.excelforum.com/member.php...o&userid=36635
View this thread: http://www.excelforum.com/showthread...hreadid=563830

simserob Wrote:
when i do that it says there's an error - i guess it doesn't recognize
the significance of the numbers...i also would need a day counter to
get the average amount earned per day.
i think with the formula you gave me, it wouldn't come out to an amount
of days...i'm not really sure though since i've never heard of the
command "ceiling"

Sorry, I forgot to put the significance into that equation. :-P

Try = today()+CEILING(AmountNeeded/AverageAmountPerDay,1)

My apologies.

Scott


--
Maistrye
------------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078
View this thread: http://www.excelforum.com/showthread...hreadid=563830

Yeah, now it works
Thank you very much for your trouble, i really appreciate it


--
simserob
------------------------------------------------------------------------
simserob's Profile: http://www.excelforum.com/member.php...o&userid=36635
View this thread: http://www.excelforum.com/showthread...hreadid=563830