+ Reply to Thread
Results 1 to 3 of 3

Deleting cell values, but not forumlas?

Hybrid View

  1. #1
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Deleting cell values, but not forumlas?

    Here is a macro-enabled solution

    If you update either A1 or B1, then C1 will adjust automatically
    If you update C1, then B1 will update automatically.

    Macros must be enable for this to work!
    Attached Files Attached Files
    Gary's Student

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. re: 1, true and 0, false forumlas coupled with couting row values
    By 4GONERS in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-06-2013, 12:47 PM
  2. Multiple separate if forumlas in one cell
    By joseclar in forum Excel General
    Replies: 12
    Last Post: 05-05-2009, 02:48 PM
  3. 2 forumlas in 1 cell
    By AlphaWolf in forum Excel General
    Replies: 5
    Last Post: 05-03-2009, 07:29 AM
  4. Deleting Cell Values
    By aaser018 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2007, 12:07 PM
  5. Deleting cell values
    By watkincm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2006, 10:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1