+ Reply to Thread
Results 1 to 6 of 6

Dragging formula to add two columns, but need to show blank when other cell is blank

  1. #1
    Registered User
    Join Date
    10-05-2018
    Location
    NYC
    MS-Off Ver
    Office 365
    Posts
    3

    Dragging formula to add two columns, but need to show blank when other cell is blank

    Evening all -

    I'm new to the forum and a standard user in excel, certainly not advanced. I am having an issue where I have the following:

    A5 = 50.00 B5 = A5
    A6 = - aka 0 B6 = B5+A6

    Hope the above makes sense. I've tried a few formulas online that I have found online, but no success. When I have 0 entered in A6 I am getting the value of B5 in cell B6. I'd like to get that to show 0 until there is a value in A6.

    Is this possible or would I need to manually drag the formula "=B5+A6" down each time to cells in column B?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,253

    Re: Dragging formula to add two columns, but need to show blank when other cell is blank

    In B6 type =IF(ISNUMBER(A6),B5 +A6,0)
    Alan


    Have you debugged your code?
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    10-05-2018
    Location
    NYC
    MS-Off Ver
    Office 365
    Posts
    3
    Quote Originally Posted by alansidman View Post
    In B6 type =IF(ISNUMBER(A6),B5 +A6,0)
    Thank you for your reply. If I have $50.00 in B5 and in A6 I have $0.00 then B6 is showing $50. Only if I delete any values in A6 will the formula show correctly. However, I need to show $0 in A6 for budgeting purpose.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,253

    Re: Dragging formula to add two columns, but need to show blank when other cell is blank

    =if(a6=0,0,if(isnumber(a6),b5+a6,0))

  5. #5
    Registered User
    Join Date
    10-05-2018
    Location
    NYC
    MS-Off Ver
    Office 365
    Posts
    3
    Quote Originally Posted by alansidman View Post
    =if(a6=0,0,if(isnumber(a6),b5+a6,0))
    Awesome! This worked perfect! Thank you so much.

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,253

    Re: Dragging formula to add two columns, but need to show blank when other cell is blank

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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] Formula to show blank if two cells are blank
    By adrenom in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-09-2016, 05:10 PM
  2. [SOLVED] Reference cell formula returning 0 when BLANK, need BLANK to show
    By williamc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-31-2016, 04:23 PM
  3. Averaging with a blank cell, needs to show blank calculation
    By Pstreicher in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-20-2015, 08:08 AM
  4. Replies: 11
    Last Post: 09-15-2014, 02:36 AM
  5. If cell blank OR another cell blank then show blank, if not display value
    By stevop622 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-09-2013, 04:07 AM
  6. [SOLVED] If one cell contains #, & other cell is blank, show message & require blank be resolved
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-19-2012, 02:23 PM
  7. Replies: 1
    Last Post: 09-23-2010, 01:24 PM

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