# Excluding cells without input from being included

1. ## 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. ## 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.

3. ## 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. ## 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
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. ## Re: Excluding cells without input from being included

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

6. ## Re: Excluding cells without input from being included

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

7. ## Re: Excluding cells without input from being included

To Attach a File:

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.
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. ## 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

9. ## Re: Excluding cells without input from being included

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

10. ## 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. ## Re: Excluding cells without input from being included

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

12. ## Re: Excluding cells without input from being included

Think I might have it right this time, Thanks

13. ## 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?

14. ## 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. ## 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

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

#### 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