Results 1 to 4 of 4

Thread: Delete data without deleting the formula

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 12-09-2013, 01:13 AM #2
    jolivanes
    jolivanes is offline
    Junior Member
    Join Date
    Jan 2012
    Posts
    10
    Rep Power
    0
    The data is the result of the formula, so no, you can't
    Clear the values in Columns B and C and use this Formula.
    PHP Code:
    =IF(OR(B3="",C3=""),"",SUM(B3:C3)) 
    Last edited by bakerman; 12-10-2013 at 08:24 AM. Reason: Tags added
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. DELETE PAST FORMULA IN EMPTY CELLS
    By Zayn_21 in forum Excel Help
    Replies: 1
    Last Post: 08-15-2013, 05:39 PM
  2. VBA Confirm Message Before Deleting Row
    By mackypogi in forum Excel Help
    Replies: 14
    Last Post: 08-12-2013, 11:23 AM
  3. Deleting a Row with a specific data shown.
    By jffryjsphbyn in forum Excel Help
    Replies: 1
    Last Post: 07-18-2013, 03:41 PM
  4. Deleting Records Using Join
    By MMishra in forum MS-Access Tips And Tricks
    Replies: 0
    Last Post: 04-24-2013, 04:06 PM
  5. Deleting blank rows
    By Rasm in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 04-14-2011, 03:14 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
  •  

Forum Rules