Google Sheets custom formula to check for primality

formula.js

/**
* @customfunction
*/
function ISPRIME(number) {
    for (var i = 2; i <= Math.sqrt (number); i++) {
        if(number % i === 0) {
            return false;
        }
    }
    
    return number > 1;
}