Hi All,
I need to achieve the following but am not JET saavy enough to figure it out on my own. Any help appreciated!
IF $AL8 = "01/00/1900" then " " (field is left null/blank) IF $AL8 NOT "01/00/1900" then use the following logic =IF(AND($W8<=$AL8,(AND($AL8>0,$W8>0))))),$AL8-$W8,"0")
I hope that makes sense?
Thanks!
K
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi K,
Couldn't you just do something like this:
=IF($AL8=0," ",IF(AND($W8<=$AL8,(AND($AL8>0,$W8>0))))),$AL8-$W8,"0"))
Since 1/0/1900 is actually just the number 0 formatted as a date in Excel, I think this should work. Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts That is exactly what I was "trying" to do. I just could not get the syntax right. thank you very much!
Please sign in to leave a comment.