Posted to microsoft.public.excel.misc

Kelly Lim

Posts: n/a

any auto formula changing 1 - 31st everyday & multiply $975

Hi excel users,

I'm trying to work on a simple calculation which i cannot figure out the
formula.

Let's say in this column i have: 1 * $975 = $975

How can i make the "1" automatically changes to 2,3,4,5, and to the end of
the month 30th/31st, so that the the figure will be auto calculated adding
each day:
2 * $975 = $1950

Thanks in advance!!
Regards,
Kelly

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamic Range with unused formula messing up x axis on dynamic graph	[email protected]	Charts and Charting in Excel	2	February 2nd 06 08:02 PM
Auto Extend Formulas doesn't work for a particular formula	niwrad	Excel Discussion (Misc queries)	3	January 9th 06 09:36 AM
Copying a formula and changing ONE value...	JSA	Excel Worksheet Functions	2	February 18th 05 05:13 AM
HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE	anantth	Excel Discussion (Misc queries)	4	February 6th 05 12:25 PM
auto sum in formula	hbpvs	Excel Worksheet Functions	5	December 21st 04 12:34 PM

All times are GMT +1. The time now is 11:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us