sorry ignore first part, see tables. Change example, forgot to deleteacopper57 wrote:
gt;I am wondering how to add to a previously summed number. For example, I had
gt; .4420 .0080 .0020-.0025 .0075 - .0040 in a cell with a closing value of .
gt;4530. Next week I would like to be able to add my change, let us use as
gt;example .0085 to the summed figure, not having to add .0085 to the end of
gt;the cell.
gt;
gt;Example:
gt;new price
gt;price zoneOld Priceweek 1week 2week 3week 4week 5
gt;A15.000015.008015.010015.004015.002515.0070
gt;B14.000014.008014.010014.004014.002514.0070
gt;C13.000013.008013.010013.004013.002513.0070
gt;D12.000012.008012.010012.004012.002512.0070
gt;E11.000011.008011.010011.004011.002511.0070
gt;F10.000010.008010.010010.004010.002510.0070
gt;
gt;price chngweek 1week 2week 3week 4week 5
gt;week 10.00800.0020-0.0060-0.00150.0045
gt;
gt;However I would like my spreadsheet to just be able to keep the end price of
gt;15.0070 and add new change to that figure without to keep the 15.00 .0080
gt; .0020 - .0060 - .0015 .0045 showing in cell.
gt;
gt;clear as mud, I need help!!
--
Message posted via OfficeKB.com
www.officekb.com/Uwe/Forums.a...tions/200605/1
- Apr 13 Sun 2008 20:43
Add to Summed Figures
close
全站熱搜
留言列表
發表留言