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 ]