Blank Cells in Google Sheets? || If Cell is Blank Return Value or Blank

You may not always have all the data. Sometimes the data is not available, not applicable or just blank. In these situation you don’t want Google Sheets to calculate a zero (0) or result in an Error message such as #Value #Error #Div/0! error, which if you use the result in further calculations, will result in further errors. You can’t use the IFBLANK formula from Excel as it is not available in Google Sheets but there are three other ways to solve this issue.

In this video you will learn three ways, three different formulas to solve the blank cell problem. You will be able to return blank when the cell is blank and produce a result when the cell has data.

———————CHAPTERS—————————
00:00 - Intro
01:39 - Can I use IFBLANK in Google Sheets?
02:20 - Option 1 - If Not Blank
03:00 - Option 2 - If Blank
03:38 - Option 3 - ISBLANK Formula

#akaakidesign #akistepinska

[DadInTaiwan]

Thank you! This is exactly what I was looking for, and you explained it simply enough for me to understand 🙂

[vipinvlogs-techpettravel]

🙏 Thanks. I got what i want. Keep the good work going.

[lizgannon]

Omg thank you so very much....ive been watching videos for hours trying to figure this exact thing out....and it all worked !!!!

[rodrigoprettodeoliveirarpo]

Thanks, amazing and wonderful explication. God Bless you

[lilpalmed]

I just tried your first and second method but it wasn't working. The formula wasn't recognizing cells after the condition. So instead of ", " I've put ";" and it worked. It gives =SI(E6<>"";E6-C6;""). Maybe an update so if people face the same problem they know how to fix it.
Anyway thank you for your video, I wouldnt find this without your base.

[robertreyes]

Great video. Thank you.

Question for you if you don’t mind. I’m struggling to write a function for this problem.
Example: F4 needs to equal the value in I4, unless K4 has a value, then F4 needs to equal K4?

[yashkotak]

Thank you for your tutorial...but if i have 2 different cell in which value is dependent,
Like in second option, if b19 and c19 both are empty then show d19 blank
What will be the formula for it..?

[joseignaciofonseca]

Thanks Aki! ... Your video was useful to me

[miguelate]

I have a freeze row on top of each column with a title for the column. If a cell is blank below that column, I want to be able to change the color of the that cell to indicate that there is a blank cell in the below or more than one. There aren't supposed to be any empty cell. If there is one, a person is supposed to fill in with data. A change in color on that top cell allows the data entry person to know there is an empty cell and enter data as needed. I tried conditional formatting, but it changes the color of that specific cell that is empty, and I want to only change the color of that top cell on top. Thanks for the other reply.. I appreciate it. I guess this could be achieved with a combination of a formula and conditional formatting, but I am not sure how.

[mayxie]

How about there are 2 checks required before calculation?

[chrissadleir]

This video helped me out so much, thanks for the great info!

[miguelate]

I have a sheet that imports data from 2 different sheets through import range formula. The data appears in A1:A10 from one sheet and B1:B:10 from the other. We want to be able to type in any field without affecting the formula on the first row, which is import range. Is there a way of doing that. We want to be able to write over cells that are left blank, but with a formula on top we can't. Is that even possible?

[markloundy]

How can I apply this to ranges of potentially blank cells? When I try =IF(BR3:BR36="", "", =COUNTA(BR3:BR36)) Then I get an error and the calculation for actual entries doesn't happen. I also can't put parentheses around the first range expression.

[giancarloshipolito]

Thanks for this worthy knowledge Miss Aki!

[hugogarcia]

I have formula IF=(F6>=(TODAY(), "Not Due", "Passed Due") but I'm trying to make it stay blank if there is no data yet with IF=F6="", ""'(F6>=(TODAY(), "Not Due", "Passed Due") but it comes as an error

[ilovecats]

how do I show items with no data in a class interval on a pivot table in google sheets?

[Dutch_Pancake]

I'm trying to pull text from another cell which is =D28.
However, if D28 is empty I want a text shown, but whatever I try, it always shows an error.

=IF(D28="", "Edit in DEPARTURES section", =D28)
=IF(ISBLANK(D28)=TRUE, "Edit in DEPARTURES section", "TEST")
=IF(D28<>"", =D28, "Edit in DEPARTURES section")
etc, etc,

My goal is to show the text from cell D28 in cell D55, but if cell D28 is empty, I want it to show "Edit in DEPARTURES section" in cell D55.
Does anyone know how I can achieve this?

Thanks

[markloundy]

When I try =IF(ISBLANK(BR3:BR36), , COUNTA(BR3:BR36)) I get an ERROR.