Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default Updating an inception-to-date formula

Does anyone know an easy way to automatically update the fixed value in an
ITD formula?

Let's say I'm putting the current month's value in A1, with an ITD formula
in B1. $5 has been spent to date, $2 more is spent in the current period.

Current formula in B1: =A1+5 (value $7)

To prepare for the next month, any ideas on how to get the formula in B1 to
automatically update to =A1+7 before I blank out the content of A1?

I'm currently doing this with helper columns to write the updated formulas
for hundreds of rows, but that has its risks as one of the helper columns
must contain the worksheet's row number as a value (and this can get out of
synch easily after inserts/deletions/sorting).

If there are no better solutions to the ITD formula than what I'm currently
doing, any suggestions for a function which will simply return the row number
as a value in a cell?

TIA.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Updating with current date Gloria Lewis Excel Discussion (Misc queries) 0 February 26th 08 08:55 PM
date updating Katie Excel Worksheet Functions 1 August 17th 07 11:48 PM
updating date! via135 Excel Worksheet Functions 3 February 23rd 06 05:31 PM
How do I stop a date from automatically updating? Canwoman88 Excel Discussion (Misc queries) 5 January 9th 06 07:12 PM
printing while updating date... soundgarden Excel Discussion (Misc queries) 1 November 1st 05 10:57 PM


All times are GMT +1. The time now is 03:49 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"