Related:
- Which function will you use to enter current time in a worksheet cell
- If function for time range in excel - Guide
- Nested IF functions using time values ✓ - Forum - Office Software
- IF functions with TIME functions ✓ - Forum - Office Software
- If function with time - Forum - Excel
- Enter current time in a cell by clicking it ✓ - Forum - Office Software
1 reply
Are you qualifying the false value? If not, then it will display false, as it is not true. Syntax for if is:
=IF (test, true, false)
If your formula looks like this:
=If (test, b1)
Then it will display false, as you need to set what value to display if it is false, as in:
=If (test, b1, c1-b1)
In the above example, if the result of test is true, then the value of b1 will be displayed. If test is false, then the vakue of c1-b1 will be displayed.
Get it?
=IF (test, true, false)
If your formula looks like this:
=If (test, b1)
Then it will display false, as you need to set what value to display if it is false, as in:
=If (test, b1, c1-b1)
In the above example, if the result of test is true, then the value of b1 will be displayed. If test is false, then the vakue of c1-b1 will be displayed.
Get it?