Return empty cell from formula in Excel

0 votes

I need an Excel formula to return an empty cell, however it seems that Excel treats a reference to an empty cell or an empty string differently from an actual empty cell. In essence, I require something like:

=IF(some_condition,EMPTY(),some_value)

I tried to do things such as

=IF(some_condition,"",some_value)

and

=IF(some_condition,,some_value)

and assuming B1 is an empty cell

=IF(some_condition,B1,some_value)

I assume they are the outcome of a formula, but none of these seem to be genuine empty cells. Is it possible to maintain a cell genuinely empty and only fill it with data if and when a certain condition is met?

Nov 20 in Others by Kithuzzz
• 20,660 points
29 views

1 answer to this question.

0 votes
There is no way to do this in Excel. In Excel, a formula's output can only be a number, text, logical (boolean), or error value. There is no "empty" or "blank" value type for a formula cell.

However, there is a significant difference in how other functions regard NA() (SUM(NA()) is #N/A while SUM(A1) is 0 if A1 is empty), so using NA() and ISNA() may or may not actually fix the problem.
answered Nov 20 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9 in Others by gaurav
• 22,040 points
529 views
0 votes
0 answers

What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

Nov 2 in Others by Kithuzzz
• 20,660 points
25 views
0 votes
1 answer

Excel Formula - if values in columns all contain X then return

You can use the AND function: = IF(AND(A3="OK";B3="OK";C3="OK");"everything ...READ MORE

answered Nov 4 in Others by narikkadan
• 37,660 points
38 views
0 votes
1 answer
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
142 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
240 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
109 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18 in Others by gaurav
• 22,040 points
71 views
0 votes
1 answer
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP