Forum Discussion
I don't know if this can be done
Ok, I hope I can explain what I'm trying to do clear enough to get an answer. The cell A1 can have one of 4 entries, <blank>, 2, 1, 0. I need to nest an IF statement so that if the entry is either l...
your's came close - I figured it out about 10mins before you replied
=IFS(ISBLANK(A1)=TRUE,"",A1=2,1,A1=1,"",A1=0,0)
In addition to Twifoo comments.
You don't need to compare ISBLANK() with logical value, function itself returns it - TRUE or FALSE. You may use another but similar logic within IFS
=IFS( LEN(A1)=0,"", A1=2,1, A1=1,0, A1=0,0, TRUE, "")It's unnecessary long formula, but better illustrates the logic.