Software

Ask something
Discussion Locked

Excel - blank cells

0 helpful
1 reply

by dominic_wall

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In XL can anyone tell me if there's a way of first identifying a blank cell- The ISBLANK function does this- but then also returning (entering) a user-specified value into the first cell depending on the outcome? The ISBLANK function only seems to return a result of TRUE or FALSE.
Thanks for any help, D.

1 reply

by lumberjack

how about something along the line of

=IF(ISBLANK(cellreference)=TRUE, "value if blank", "something there")

This discussion is closed to new replies.