Forum Discussion
Possible error in IF function
While designing a spreadsheet in Excel 365, I was inputting an IF() function. Support documentation indicates that the [value_if_true] and [value_if_false] responses are optional. There is a problem ...
=if(condition,,) is equal to =if(condition,<blank cell value>,<blank cell value>), or =if(condition,0,0)
Other words that's =if(condition, FALSE, FALSE)
IMHO, that's not a bug.
As note, that's not blank as a value, it's not supported so far.