Show cell empty if formula referred returns nothing

tigerdel

Board Regular
Joined
Oct 13, 2015
Messages
145
Office Version
  1. 365
Platform
  1. Windows
Good evening experts

In a cell D5 I have the formula =C5+10, but if cell C5 is blank I need D5 to be blank but it is showing a return of 10/01/1900

Any ideas how I can get it to show as blank cell?

Many thanks
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
OK I tried the following formula: =IF(ISBLANK(C5),"",C5+10) but it seems that as C5 has a formula it returns #VALUE!

Any ideas??
 
Upvote 0
=IF( C5="", "", C5+10 )

whats in C5 - is it blank or zero, do you have zero's set to not display

10/01/1900

so that a date of zero or blank + 10 days

click on the cell you think is blank and see whats in the formula bar
 
Upvote 0
=IF( C5="", "", C5+10 )

whats in C5 - is it blank or zero, do you have zero's set to not display

10/01/1900

so that a date of zero or blank + 10 days

click on the cell you think is blank and see whats in the formula bar
C5 has a formula in it which has no value yet
 
Upvote 0
whats the formula , and what does it return into the cell , does it put a blank in the cell or zero ?
unless the formula in C5 is setup to have a condition where it puts "" blank into the cell, then C5 will never be blank

as you can see here , I have setup a formula in C5 to have a condition where the formula returns a blank
and then in D5 , i have a formula which looks at the value in C5 and if its blank, returns the text , "C5 is Blank" the fact that a formula is in the cell C5 does not matter , its the value that the formula in cell C5 returns

Excel Forum Demo.xlsx
BCDE
4
5 cell is blank
6
Sheet2
Cell Formulas
RangeFormula
C5C5=IF(A5="","",1)
D5D5=IF(C5="", "cell is blank", 1)
 
Upvote 0
@etaf

So this is the part of the table and the formulas

Hope this helps
 

Attachments

  • Pic1.png
    Pic1.png
    35.1 KB · Views: 3
  • Pic2.png
    Pic2.png
    49.3 KB · Views: 3
Upvote 0
i don't know what cells you have in that image
did you try my version Cell =""
as ISBLANK() sees the formula and so returns false section,

Cell Formulas
RangeFormula
C5C5=IF(A5="","",1)
D5D5=IF(C5="", "cell is blank", 1)
E5E5=IF(ISBLANK(C5),"cell is blank","cell is NOT blank")
 
Upvote 0

Forum statistics

Threads
1,213,483
Messages
6,113,919
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top