Empty cells
Hello1
How to leave empty the cells that must be when using certain formulas like VLookup, IF ...?
Is it possible to write severa questions in a single post?
null-OTHER, OS X El Capitan (10.11.6), Numbers
Hello1
How to leave empty the cells that must be when using certain formulas like VLookup, IF ...?
Is it possible to write severa questions in a single post?
null-OTHER, OS X El Capitan (10.11.6), Numbers
if you want to conditionally provide an value or nothing you can do something like:
=if(<condition>, <value>, "")
e.g. if you wanted to look at values in column B and stored only positive in column C, you could use:
=if(B1>0, B1, "")
the "" represents the empty string (or nothing)
There are no replies.
Empty cells