2 sets of double quotes is what your after... eg, =IF(C8="";"i'm blank";"I'm not blank")
/paul On 6/30/05, Gert Blij <[EMAIL PROTECTED]> wrote: > How can I create an IF statement that says: > > If a cell is blank (null (?)) do something else do something else. > > TIA > Gert > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
