+ Reply to Thread
Results 1 to 15 of 15

Excluding cells without input from being included

  1. #1
    Registered User
    Join Date
    07-25-2012
    Location
    Bristol England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Excluding cells without input from being included

    How do you exclude cells from still returning a value when the first cell in the equation has no data.
    The object is to be able to fill data along a date column that is compared to a fixed cell, i.e. $A$1 But not for all cells that are along the date column to return a value.
    B 1 is 100 A1 is 90 C1 =B1-A1= 10
    B2 is 90 A1 is 90 C2 =B2-A1=0
    B3 is blank A1 is 90 C3 Blank

    Second Question
    Is it possible to have a formula in one cell that can take information from one of two cells, using whichever one has data, and then using a formula based on which one it was taken from.
    I.e. $A$1 has data Cell C1 uses a formula to Subtract.
    $B$1 has data Cell C1 uses a formula to add
    Both A1 and B1 has Data Cell C1 returns the plus/minus difference.

    I am new to excel and really could do with some help as my background is not in computing so if you would like to become a personnel trainer in it then I would be most greatfull. My Email is davegmark@aol.co.uk and my name is dave. Have a good day either way

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,902

    Re: Excluding cells without input from being included

    You get better help if you post an Excel-example of your workbook, without confidential information.'

    Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.

    Use BEFORE/AFTER sheets if that helps make it clearer.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Valued Forum Contributor
    Join Date
    12-05-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010 & 2013
    Posts
    308

    Re: Excluding cells without input from being included

    Hi Tahoe

    Welcome to the forum.

    To answer each question in turn:
    1) Use an IF statement to check the cells are not blank:
    Please Login or Register  to view this content.
    2) You can use IF and ISBLANK again to check if one is blank. But, given the scenario, can you just always add A1 and subtract B1? That way, if A1 has a value it will be added. 0 will be added if A1 is blank, having no effect on the result.

    As oeldere says, an example may help. Use the "Go Advanced" button below, then click Manage Attachments to upload an example of what you want.

    Hope this helps.

    Best regards, Rob.

  4. #4
    Registered User
    Join Date
    07-25-2012
    Location
    Bristol England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Excluding cells without input from being included

    Thanks Rob I have just dummied up a sheet with examples of both situations that I want to returne to the same column. I.e Price and Dif column is the same but taking their choice of formula from weather there is info in either the buy or sell, cell. Sorry i have not yet worked out how to include a proper spread sheet in these treads, its all new to me. Maney thanks Dave



    Sell Sell
    95.00
    Buy Buy
    95.00

    Price Dif +/- Price Dif +/-
    01-Jan-12 01-Jan-12
    02-Jan-12 02-Jan-12
    03-Jan-12 100.00 5.00 03-Jan-12 100.00 -5.00
    04-Jan-12 105.00 10.00 04-Jan-12 105.00 -10.00
    05-Jan-12 110.00 15.00 05-Jan-12 110.00 -15.00
    06-Jan-12 105.00 10.00 06-Jan-12 105.00 -10.00
    09-Jan-12 95.00 0.00 09-Jan-12 95.00 0.00
    10-Jan-12 90.00 -5.00 10-Jan-12 90.00 5.00
    11-Jan-12 11-Jan-12
    12-Jan-12 12-Jan-12
    13-Jan-12 13-Jan-12
    16-Jan-12 16-Jan-12
    17-Jan-12 17-Jan-12
    18-Jan-12 18-Jan-12
    19-Jan-12 19-Jan-12
    20-Jan-12 20-Jan-12
    23-Jan-12 23-Jan-12
    24-Jan-12 24-Jan-12
    25-Jan-12 25-Jan-12
    26-Jan-12 26-Jan-12
    27-Jan-12 27-Jan-12
    30-Jan-12 30-Jan-12
    31-Jan-12 31-Jan-12
    -5.00 Total +/- 5.00 total +/-

    6 No of Days 6 o of Days

    ---------- Post added at 03:54 AM ---------- Previous post was at 03:52 AM ----------

    Sorry Rob looks like this site will not send as I had it on my screen, I will go back and try to send in correct format. Dave

    ---------- Post added at 04:11 AM ---------- Previous post was at 03:54 AM ----------

    Hi Rob
    How do I post an example Spreed sheet exactly. It does not seem as if I can copy and paste from Excel to hear, what should I be doing.

  5. #5
    Registered User
    Join Date
    07-25-2012
    Location
    Bristol England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Excluding cells without input from being included

    Hi Rob I think I have just attached a pdf, Thats a first for me. Dave
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    07-25-2012
    Location
    Bristol England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Excluding cells without input from being included

    [ May be not last time ATTACH]170470[/ATTACH]
    Attached Files Attached Files

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,902

    Re: Excluding cells without input from being included

    To Attach a File:

    1. Scroll down to the window below your post Additional Options
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.

  8. #8
    Registered User
    Join Date
    07-25-2012
    Location
    Bristol England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Excluding cells without input from being included

    Hi and thanks for the help, I think I have dode more or less what yoy said and hopefully will know upload
    Attached Files Attached Files

  9. #9
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,902

    Re: Excluding cells without input from being included

    The upload is succesfull.

    Maybe you can add an exel-file to work on.

  10. #10
    Registered User
    Join Date
    07-25-2012
    Location
    Bristol England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Excluding cells without input from being included

    Hi Oeldere

    Had no ideal you wouldent be able to work on it. I saved it as a PDF file in Excel and that was what I uploaded. How should I do it, to upload a workable spread sheet.

    Dave

  11. #11
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,902

    Re: Excluding cells without input from being included

    The same way you added the PDF file, you can add an Excel-file.

  12. #12
    Registered User
    Join Date
    07-25-2012
    Location
    Bristol England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Excluding cells without input from being included

    Think I might have it right this time, Thanks
    Attached Files Attached Files

  13. #13
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,902

    Re: Excluding cells without input from being included

    I don't know what youre up to, but i give it a try.

    See the yellow cells in the example.

    Is this what you're up to?
    Attached Files Attached Files

  14. #14
    Registered User
    Join Date
    07-25-2012
    Location
    Bristol England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Excluding cells without input from being included

    Thanks Oeldere

    It looks like you are on the right lines, unfortunatley i have no time right now to explain better, and will have to come back to this tommorow. Have a good evening, Dave

  15. #15
    Registered User
    Join Date
    07-25-2012
    Location
    Bristol England
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Excluding cells without input from being included

    Hi Oeldere I have attached a note to the spreed sheet which hopefully will help you understand what I am trying to acheive. I thank you in advance for your help with this matter. I also have a desire to understand how these formalas work so that I start to write them myself, so if you have the time to include a description of how and why all the symbals are there then I would very much thank you for that also. Dave

    ---------- Post added at 03:30 AM ---------- Previous post was at 03:24 AM ----------

    Not Sure if the note stuck so hear it is as well, thanks

    Hear is what I am trying to achieve. Both the examples are the same area; however the dif+/- column needs to use B3 or B5 cell in the equation depending on which one has data. The price column will vary on how many inputs are made so the Dif+/- column only wants to compute if data has been entered into the price column.

    This spread sheet is to try and help me keep track of trades, so if a stock is entered into in the sell cell, then the sell price needs to be subtracted from current price, returning a positive value, if the current price is falling, and below the sell price, and a negative value if the current price is rising, and above the sell price. On the other hand if data has been entered into the buy cell then the equation needs to be the other way round. The current price subtracted from the buy price returning a positive value if the current price is above the buy price and a negative value if it is below the buy price.

    Hope this is a bit clearer as to what I am trying to achieve

    ---------- Post added at 03:35 AM ---------- Previous post was at 03:30 AM ----------

    Some reason excel does not want me to past a word doc into your returned file of my spreed sheet example. Any ideals

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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