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

Giganews Newsgroups
Subject: any auto formula changing 1 - 31st everyday & multiply $975
Posted by:  Kelly Lim
Date: Thu, 8 Jun 2006

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

Replies