I’m trying to find a formula to check if within each row there is at least one blank cell.
Im using ISBLANK and OR.
If I do =OR(ISBLANK(A2),ISBLANK(B2),ISBLANK(C2)…) and it works
but since my spreadsheet get till column FF, it is a very long formula and I would like to shorten it using ranges capabilities of libreoffice.
I’ve tried =OR(ISBLANK(A2):ISBLANK(FF2) but got an error E:502
I’ve tried =ISBLANK(A2:FF2) but got always FALSE
Anyone can help?
Thanks so much