Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default Macro to add cell value to referring cells formula

Hi, I am trying to build a macro that adds 1 months
depreciation to a cell everytime it runs.

= 7.85 + 7.85 + 7.85 is how the result should look.

Something like:

Search A:A

If Cell in Column A Isnumber

Add (+)Cell Value to end of formula in same cell # in
Column B


Any ideas how to approach this?


Thanks,

Todd.
..


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
The result of a formula referring to a cell with formula as text? JCC Excel Worksheet Functions 10 September 3rd 09 03:15 PM
Referring to cells on other sheets using formula ClaireS Excel Discussion (Misc queries) 3 August 4th 09 12:03 PM
IF Formula referring to 2 cells Marilyn Excel Discussion (Misc queries) 1 March 22nd 09 08:45 PM
excel formula referring to a decimal portion of another cell teenerx5 Excel Worksheet Functions 1 February 24th 07 05:58 PM
formula works when referring to one cell but not to another Nicci New Users to Excel 3 July 7th 06 02:03 PM


All times are GMT +1. The time now is 05:06 PM.

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

About Us

"It's about Microsoft Excel"