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 ...
I agree that value_if_true and value_if_false should always be included, but they are listed by Microsoft Support as optional. Perhaps the IF() function should generate an error if either argument is left out.
Optional parameters quite often (not always) return zero. For example, =MAX(-1,) gives 0.