Using Alpha Characters in IF Statement

[AssetHound]

IF(ENDDAYS()-STARTDAYS()>100,100,"n/a")

Can I have one of the resulting values from an IF statement be non-numeric as in the above simple example? I don't seem to be able to make that happen. Thanks.

[Mark]

Hi AssetHound,

Sorry, no, equations cannot include text. You can include numbers, built-in fields, or any of the supported functions.