Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cells are up to date

    Working on a budget program. I need to reference a cell that has a date in it (B5). When information is entered into the budget (i.e. 20-jun(B5) deposited $1050(B7)) I need in like two other places (G4 and J8) to automatically insert B5's date that was entered.

    But... if B5 does not have a date entered ... also... how do you have it display blank in G4 and J8?

    So until B5 has a date entered, i cannot have anything in G4 and J8.

    I have tried to do it with SUM... in the G4 and J8 cells (i.e. =SUM(B5)) this is the formula and all it displays is 0-jan when nothing is entered. Is there a way to display a blank cell?

    Thanks in advance for anyone helping this newbie at Excel 2002. I appreciate any comments or suggestions.

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,180
    Thanks
    47
    Thanked 983 Times in 913 Posts
    =if(isnumber(B5),B5,"")

    =if(B5<>"",B5,"")

    =if(B5>0,B5,"")

    cheers, Paul

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,635
    Thanks
    115
    Thanked 649 Times in 592 Posts
    Or place in the cell
    =if(B5="","",B5)
    Read as "if B5 is blank then value is blank else the value is the same as B5"

  4. #4
    New Lounger
    Join Date
    Jul 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    THANK YOU!! Both of you are awesome... works like a charm

Posting Permissions

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