Summary
In this video we look at how to make Excel return the appearance of a blank value.
Tab in example file: Blank values
Excel cannot return a blank cell, it always returns 0. Instead we can return an empty text string to give the appearance of a blank value.
The functions introduced in this video are ISBLANK and LET.
ISBLANK – Checks if a value blank and returns TRUE or FALSE.
The syntax for ISBLANK is:
=ISBLANK(value)- value – the the cell to test
LET – Assigns calculation results to names that can be reused within a formula.
The syntax for LET is:
=LET(name1, value1, [name2], [value2], …, calculation)- name1 – The first name
- value1 – The value to assign to name1
- [name2] – The second name
- [value2] – The value to assign to name2
- … – On-going pairs of names and values
- calculation – The calculation or value to return
Names must start with a letter, or an underscore, and cannot conflict with other name or range references (e.g. A1 is not a valid name)