- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 June
- any auto formula changing 1 - 31st everyday & multiply $975

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

- Re: any auto formula changing 1 - 31st everyday & multiply $975 posted by Bondi on 8 Jun 2006
- Re: any auto formula changing 1 - 31st everyday & multiply $975 posted by Norman Jones on Thu, 8 Jun 2006
- Re: any auto formula changing 1 - 31st everyday & multiply $975 posted by Roger Govier on Thu, 8 Jun 2006