This should do what you are looking for:
IF(
password,
IF(
LOWER(password) = LOWER({re-password}),
"
same",
"
not same"
),
"
blank"
)
However, are you certain you want to ignore case?
Passwords are usually case-sensitive, and if you are running a web-service that does not support case-sensitive passwords, I would urge you to change that to allow case-sensitivity – just my 2 cents.
This should do what you are looking for:
IF(
password,
IF(
LOWER(password) = LOWER({re-password}),
"
same",
"
not same"
),
"
blank"
)
However, are you certain you want to ignore case?
Passwords are usually case-sensitive, and if you are running a web-service that does not support case-sensitive passwords, I would urge you to change that to allow case-sensitivity – just my 2 cents.
+1 for nice use of the ‘Sleeping Symbol’ emoji…