+ Reply to Thread
Results 1 to 7 of 7

Making a cell blank once everything is satisfied

  1. #1
    Registered User
    Join Date
    06-16-2016
    Location
    Michigan
    MS-Off Ver
    office365
    Posts
    26

    Cool Making a cell blank once everything is satisfied

    Im trying to keep a running total of days when something is borrowed, but when the item is returned I'd like that running total to disappear when the item is returned. and then Id like that total to be then put into a different cell. I'm sure I can make the last part happen. But I am using the following formula to calculate days out "=IF(COUNT(TODAY(),E10)<2,"",(TODAY()-E10))" which returns the current days the item has been out. But when I add the return date into cell E11 I'd like the cell the formula in to return back to blank(Or if it is possible to have it stop calculating days at that point and just leave the days out in that same column). Then I will have a different cell that calaculates the total days out. Is this possible or wishful thinking. I'm sure it is possible because this program is amazing.

    Thank you for all the help.. This forum is awesome, and all of you who help are amazing people.
    Last edited by EMcCausland; 12-15-2016 at 01:24 PM.

  2. #2
    Registered User
    Join Date
    06-16-2016
    Location
    Michigan
    MS-Off Ver
    office365
    Posts
    26

    Re: Making a cell blank once everything is satisfied

    Or maybe if it is possible to have it return a Value of "Returned" in the cell that did have the numerical value once the return date is entered into cell e11

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,324

    Re: Making a cell blank once everything is satisfied

    How about this?

    =if(E11<>"","",IF(COUNT(TODAY(),E10)<2,"",(TODAY()-E10)))
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Registered User
    Join Date
    06-16-2016
    Location
    Michigan
    MS-Off Ver
    office365
    Posts
    26

    Re: Making a cell blank once everything is satisfied

    Thank you worked exactly how I wanted it to.. Is it possible you might be able to explain that formula in lamemans terms for me so I can better understand how it works?

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,324

    Re: Making a cell blank once everything is satisfied

    Yes, of course. First it looks at E11 to see if there is anything in the cell, and if it does, it returns a blank. If it doesn't, it goes on to do the calculations that you set up in your original formula. In other words, if the first argument is met, it does not go on to execute the rest of the formula. Hope this makes sense.

  6. #6
    Registered User
    Join Date
    06-16-2016
    Location
    Michigan
    MS-Off Ver
    office365
    Posts
    26

    Re: Making a cell blank once everything is satisfied

    yup sure does... thank you so much

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,324

    Re: Making a cell blank once everything is satisfied

    You're welcome! Merry Christmas!

+ 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. [SOLVED] Making a cell blank referring to another blank cell
    By JUDSON_IRELAND in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 05-08-2014, 12:06 PM
  2. Excel 2007 : Formula making a cell blank
    By Harlort in forum Excel General
    Replies: 3
    Last Post: 10-27-2011, 01:21 PM
  3. Making a Cell Value of 0 remain blank
    By jonvanwyk in forum Excel General
    Replies: 1
    Last Post: 08-05-2010, 02:33 PM
  4. Making a cell appear blank
    By fredlake in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 02-08-2010, 11:53 AM
  5. Making cell value blank
    By phil2006 in forum Excel General
    Replies: 6
    Last Post: 09-23-2008, 02:12 PM
  6. Making a Cell Blank
    By papa_face in forum Excel General
    Replies: 4
    Last Post: 05-04-2008, 12:16 PM
  7. Making Cell Blank
    By [email protected] in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2006, 11:55 PM

Tags for this Thread

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