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 you omit value_if_true, the return value will NOT be TRUE if the condition is met. From IF function:
Common problems
|
Problem |
What went wrong |
|---|---|
|
0 (zero) in cell |
There was no argument for either value_if_true or value_if_False arguments. To see the right value returned, add argument text to the two arguments, or add TRUE or FALSE to the argument. |
So you should always provide both value_if_true and value_if_false