Return empty cell from formula in Excel

by

Excel does not have any way to do this.

The result of a formula in a cell in Excel must be a number, text, logical (boolean) or error. There is no formula cell value type of “empty” or “blank”.

One practice that I have seen followed is to use NA() and ISNA(), but that may or may not really solve your issue since there is a big differrence in the way NA() is treated by other functions (SUM(NA()) is #N/A while SUM(A1) is 0 if A1 is empty).

More Related Contents:

  1. Calculation is wrong, Rounding wrong
  2. Excel formula checklist in employees
  3. Sequence of numbers based on start and end value of 2 cells [closed]
  4. Error in finding last used cell in Excel with VBA
  5. Excel VBA – How to add dynamic array formula
  6. Vlookup using 2 columns to reference another
  7. Referencing value in a closed Excel workbook using INDIRECT?
  8. Ignore Duplicates and Create New List of Unique Values in Excel
  9. Excel Formula for Inventory
  10. Find last used cell in Excel VBA
  11. Two column lookup in table array using INDEX and MATCH
  12. Using UNIQUE with non-adjecent columns on different sheets
  13. Excel Date to String conversion
  14. Concatenate column headers if value in rows below is non-blank
  15. If two cells match, return value from third
  16. What does — do in Excel formulas?
  17. Optimizing Excel formulas – SUMPRODUCT vs SUMIFS/COUNTIFS
  18. How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
  19. Using the value in a cell as a cell reference in a formula?
  20. Countif With Multiple OR Criteria
  21. Excel – extracting top 5 values
  22. Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)
  23. CountIf With Filtered Data
  24. How to count cells in a range with a value less than another cell in excel?
  25. Extract the last substring from a cell
  26. How to extract text within a string of text
  27. Excel: How to gather unique values in one column that are associated with duplicates in another column?
  28. How to roundup a number to the closest ten?
  29. Convert an Array Formula’s Text Results into a Usable Format
  30. Can’t pass a range to a lambda using Let and Makearray functions

Leave a Comment