I have a formula; =if(THIS;THAT) which works GREAT.
I would like to add a third parameter; IF() so that when the value of THIS is exceeded, the third parameter is displayed in the cell.
Tried both of these:
=IF(TODAY()-C4>190,"Send Now",TODAY()-C4, "Ready")
=IF(TODAY()-C4>190,"Send Now",TODAY()-C4)elseif (TODAY()>190,"READY")
Both resulted in ERRORs, 504 and 509
Ideas?
Thanks, ⌡im
[erAck: edited to codify using ```, see This is the guide - How to use the Ask site? - #6 by erAck ]
You may want to consider what I wrote in my answer here: Why do I often get an error (508, 504, 502 e.g.) if I paste a Calc formula from some post into my sheet? .
This worked for only on my test cell 
=IF(TODAY()-C4>190,"Send Now",TODAY()-C4,"READY")
Thanks anyway, ⌡im
[erAck: edited to codify using ``` ]
Have written this formula 100 different ways … Still won’t work
=IFS((C2="","Send Now"),(TODAY()-C2>190,"READY"),(TODAY()-C2))
| Col C | Col D |
|---|---|
| 20. Feb. 2022 | #N/A |
| 10. Jan. 2022 | Err:509 |
| 30. Dec. 2020 | Err:509 |
| Err:509 |
Col C is formatted as date and data is entered
Col D is where the fomula is locates and then was copied down
Another question re: formulas: Does CALC continue assessing the formuls after 1 of the arguments = TRUE?
That might explain my problem
More thanks are due.
⌡im
[erAck: edited to codify using ``` and fix table, again see This is the guide - How to use the Ask site? - #6 by erAck ]
IF(), but not (e.g.) for REGEX(). .It is correct for all Calc functions. In Calc, whenever you use an argument separator, you set the following argument - unlike some programming languages, where there is a way to use two separators in a row to have corresponding argument unset. In the ;; case, the set argument would be empty parameter (which, again, is different to “missing optional parameter” - see ODF 1.3 part 4 sect. 5.6). The empty parameters may be specified to be handled specially; otherwise, the standard makes it application-defined if they are accepted. Calc treats them as an empty string (in position of a string argument), or 0 (where number is expected), or a matrix with a single 0 element (where matrix is expected). This makes e.g. this different:
=INDIRECT("A1")
(missing second optional parameter is treated as 1, i.e. A1 syntax of reference)
=INDIRECT("A1";)
(empty second parameter is treated as 0, i.e. R1C1 syntax of references, making this formula fail)
However, for the IF() function that paragraph is a bad example because it talks of 4 parameters whereas IF() only has 3.
</nitpick>