Feb 16 2020 08:30 AM
Hi I am trying develope a formula
=IFS(OR(ISBLANK(AB32),ISBLANK(AB33)),"",AB32>AB33,3,AB32<AB33,1,AB32=AB33,2)
it works when AB32 and AB3 are empty, but if I import values into the cells it then ignores the blanks.
Any surgestions?
Thanks. Jim
Feb 16 2020 09:33 AM
Jim, I din't catch. If you import any value cell becomes not blank. Or you mean not blank cells, but ones with empty strings?