What is the Formula Fx if the excel formula is multiple condition and blank

Question

IF Column A = Blank Then "N", ELSEIF Column A = USGA Then "N-USGA" ELSE "Y"

Capture5.PNG

binu_acs · Accepted Answer

@jetmey use the isEmpty() function check the blank

IF isEmpty([Column A]) Then "N" ELSEIF [Column A] = "USGA" Then "N-USGA" ELSE "Y" ENDIF

Deano478 · Accepted Answer

@jetmey to add to @binu_acs solution if your blanks are Nulls the just replace isEmpty with isNull in binuacs formula