How to have a cell display nothing if formatting is in it

[FrankE67]

Hi all. been messing with this for a few days now and can't seem to get it right.
So the situation is i have a worksheet that has the following in it already:
C8, D8, and E8 have =c6+c7, =d6+d7, and =e6+e7, etc. This goes on in C14, D14 and E14.
C10, D10, and E10 have =c8-c9, d8-d9, and e8-e9.
E9 is always 1, all other fields are per input.
My issue is I want E10 to be blank if there is no input in E8. But with the formulas it always bring a -1. how can i do this so E10, E16, etc remain blank if there is no input in the other fields(E8)?
AB C D E

 

[etaf]

=IF( E8="","", the formula you want if E8 is NOT blank)

same sort of IF for E10, E16
or i may be Misundertanding

Note: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet. Plus we cannot see any of the formulas used.

Therefore -

A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.

This will possibly enable a quicker and more accurate solution for you.

MrExcel has a tool called “XL2BB” that lets you post samples of your data and will allow us to copy/paste your sample data into our Excel spreadsheets, saving a lot of time.

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

You can also test to see if it works ok, in the "Test Here" forum.

Test Here

Use this forum to test your signature, learn bbcode, smilies, XL2BB, etc. Threads in this forum are automatically deleted after no replies for seven (7) days

www.mrexcel.com

OR if you cannot get XL2BB to work, or have restrictions on your PC

then put the sample spreadsheet onto a share

I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed

Make sure you set any share or google to share to everyone

 

[FrankE67]

Thanks for the reply. I forgot to add the formatting in E6 to show what i have done. in E6 i have =IF(ISBLANK(E4),"",E4-E5), but because E4 has =E2+E3 it brings -1 in E6, instead of E6 being blank.

As far as XL2BB, i will do that when I get home. not allowed on the pc i am using right now. I will insert a portion of the workbook then

 

[Scott Huish]

You're referencing different cells now than when you started.

If the subtract 1 day is always you don't really need to reference that cell.
=IF(E8="","",E8-1)

seems like it should suffice.

 

[FrankE67]

thanks Scott but when i try that one i still get a -1 in e16. i realized when i got home yesterday that i had forgotten to send the email to myself. i sent it this morning, so when i get home i will upload a mini sheet a

 

[Scott Huish]

Can you please stay consistent in what cell we are referring to, that formula was intended for cell E10 as you originally mentioned.

If you're now not putting it in E10.
For E16, it should be =IF(E14="","",E14-1)

 

[FrankE67]

my apologies. i am doing to many different things here at work and really got confusing with the description. when i get home tonight i will upload the sheet so that you can see what i am saying.
new start:
E8 is formatted with =E6+E7
E9 will always have a 1 in it
E10 is formatted with =E8-E9
using the formula that you give it still brings a -1 in E10 because it has a formula in it (i am assuming, because when i remove it (the formula in E8) i get a black cell in E10.
Like i said i will upload it so you can see it better.

 

[Scott Huish]

In E10, try this:
=IF(COUNT(E6:E7)=2,E8-E9,"")

 

[FrankE67]

ok i couldn't get xl2bb to work so here is a link to the file:
Timeline TEST.xlsm
The thing i am trying to do is is get rid of the 1 in E10, E16, etc. It changes to the correct number when a date is put in in C6:E6, etc. It is only a visual thing that just bugs me when i look at the sheet, not something that has to be removed. i know it is probably just a need for a different formula for E8(etc), but i cant find one that works. I think it just keeps the 1 because of the formula in E8 (etc), but not sure.

 

[kevin9999]

How about (for example in E10)

=IF(E8=0,0,E8-E9)