Re: [libreoffice-users] [SOLVED] Re: Calc 6.0.6.2 IF criteria statement help

2018-11-17 Thread Remy Gauthier
Hi, To answer your question about the CONCATENATE("<>","Y"), I am looking for something that is not explicitly marked as reconciled (not "Y"). This test will mark as not reconciled all entries having an "N" (or anything else for that matter) and all blank entries (a blank cell obviously not being

Re: [libreoffice-users] [SOLVED] Re: Calc 6.0.6.2 IF criteria statement help

2018-11-15 Thread Hylton Conacher (ZR1HPC)
Hi Remy, On 2018/11/13 01:22, remygauthier wrote: Hi, Unclaimed_slips.ods I went back to the original post and downloaded the file you had uploaded to Google Drive. I made what I think were the