I'm trying to create a function that measures ages and returns adult, youth, or nothing. I have some cells that don't contain ages, and I need them to return a blank value.

This function sorts the ages. =ifs(A6 < 18,"youth", A6="", "", A6>=18,"adult")

These functions make certain cells blank. =if(C17>=18,"adult", "") =IF(ISBLANK(C2),,A2/B2)

enter image description here


Try simply to start with blank case as Google Sheet identifies it as less than 18


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.