+ Reply to Thread
Results 1 to 6 of 6

Subtracting a 0 from a empty cell and wanting to return a empty cell

  1. #1
    Registered User
    Join Date
    10-16-2019
    Location
    Idaho
    MS-Off Ver
    MS Office 2016
    Posts
    3

    Subtracting a 0 from a empty cell and wanting to return a empty cell

    Hi I have hopefully a quick question.

    I have two cells, the first is a hard 0 and the other is blank for a user to input a value.
    They are subtracted from each other with a formula for a final solution.
    I have a conditional format that says if it is plus or minus 3 it is good otherwise it is bad.

    The problem I have is that the blank is treated as a 0 in excel and returns a 0 to the final value before someone even enters a number in the sheet... Any thoughts on how I can get around this? Thanks.

    current 0-(blank) = 0
    needed 0-(blank) = Blank, or 0-0=0, or 0-5 = -5 etc...

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,072

    Re: Subtracting a 0 from a empty cell and wanting to return a empty cell

    Hi & welcome to the board.
    Maybe something like
    =IF(B1="","",A1-B1)

  3. #3
    Registered User
    Join Date
    10-16-2019
    Location
    Idaho
    MS-Off Ver
    MS Office 2016
    Posts
    3

    Re: Subtracting a 0 from a empty cell and wanting to return a empty cell

    Fluff13 Thank you for your response... That seems to work!

    I messed the equation up at first with only one set of " marks then noticed your wrote "" two quotation marks. Can you explain the difference just for my learning?

    THanks again!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,072

    Re: Subtracting a 0 from a empty cell and wanting to return a empty cell

    The double quotes "" represents a blank cell or cell that has no value.

  5. #5
    Registered User
    Join Date
    10-16-2019
    Location
    Idaho
    MS-Off Ver
    MS Office 2016
    Posts
    3

    Re: Subtracting a 0 from a empty cell and wanting to return a empty cell

    Perfect! Thank you so much for the help!

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,072

    Re: Subtracting a 0 from a empty cell and wanting to return a empty cell

    You're welcome & thanks for the feedback

+ 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. Move last cell in column to the next right empty cell if row in sheet is empty
    By Daijhan97 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-23-2019, 07:05 AM
  2. [SOLVED] Using macro to find first empty cell in column. If range is empty returns error.
    By A440 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-23-2019, 11:03 AM
  3. [SOLVED] Formula to not change the value in the cell, but for empty cell, return: `checked`
    By Sherran in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-19-2019, 06:51 AM
  4. [SOLVED] vba code to find and paste data to next empty cell, not last empty cell
    By hkbhansali in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2018, 10:48 AM
  5. Conditional IF statement finding and subtracting next non empty cell
    By duggylou in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-25-2018, 07:21 AM
  6. [SOLVED] Paste formula to the last empty cell based on a non-empty cell on another column
    By bhenlee in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-02-2015, 04:07 PM
  7. [SOLVED] Return empty cell if another cell is empty
    By dcdoc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-19-2013, 03:07 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