IF() syntax
IF() syntax
Hi,
I want to perform a function only if a condition is true. If the condition is not met then i want the cell to be empty / null.
I've tried something simple like this
=IF(0>1;1)
This condition will obviously never be met, but rather than leave the cell blank it puts 'FALSE' into the cell.
How can I make it completely empty (ie NULL).
Thanks for any help.