Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1176262%22%20slang%3D%22en-US%22%3EFormula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176262%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20am%20trying%20develope%20a%20formula%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIFS(OR(ISBLANK(AB32)%2CISBLANK(AB33))%2C%22%22%2CAB32%26gt%3BAB33%2C3%2CAB32%3CAB33%3E%3C%2FAB33%3E%3C%2FP%3E%3CP%3Eit%20works%20when%20AB32%20and%20AB3%20are%20empty%2C%20but%20if%20I%20import%20values%20into%20the%20cells%20it%20then%20ignores%20the%20blanks.%3C%2FP%3E%3CP%3EAny%20surgestions%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%26nbsp%3B%20Jim%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1176262%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

1 Reply
Highlighted

@Jim4-1945 

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?

Related Conversations
SharePoint 2013 LIst Filters (by latest date)
dmphil in SharePoint on
0 Replies
Leap year formula
Hattsoff in Excel on
4 Replies
FORMULAS
aayushman_mishra in Excel on
4 Replies