Forum Discussion
Solved
IF (logical;yes; no) How to use a Date function in the result ?
I need to add a Date function as a result in an IF formula.
I tried =IF(R4>0;Date;"") but the result is #¿.... an error.
How I would do it ?
Thank you any help
- DATE must have arguments for YEAR, MONTH, and DAY. For example, your formula might look like this:
=IF(R4>0,
DATE(2019,3,18),
“”)
The formula returns March 18, 2019, if the value of R4 is more than 0; otherwise, it returns an empty text (“”).
3 Replies
- DATE must have arguments for YEAR, MONTH, and DAY. For example, your formula might look like this:
=IF(R4>0,
DATE(2019,3,18),
“”)
The formula returns March 18, 2019, if the value of R4 is more than 0; otherwise, it returns an empty text (“”).- Thank you Twifoo, it was a bad command I knew, I guessed at beginning maybe this IF command would not accept a funtion in its results, but then I saw a sample, so I thank you very much.
- In the formula, DATE returns the value_if_true argument of IF. As you will discover, you can use a function to return an argument of another function. Good luck.
