G
Guest
I have a list with some blank cells, say in column A. I have created an IF
function to show a text message if the cell is empty. I have done it using
the ISBLANK function and also using >=0. See the next examples:
=IF(ISBLANK(A1),â€Chaseâ€,â€â€)
=IF(A1<=0,â€Chaseâ€,â€â€)
Is there a problem I might encounter if I use the <=0 condition? Is one
solution preferable for any reason to the other?
I’ve formatted the cells in column A to Text to see if that effects it and
it doesn’t seem to.
function to show a text message if the cell is empty. I have done it using
the ISBLANK function and also using >=0. See the next examples:
=IF(ISBLANK(A1),â€Chaseâ€,â€â€)
=IF(A1<=0,â€Chaseâ€,â€â€)
Is there a problem I might encounter if I use the <=0 condition? Is one
solution preferable for any reason to the other?
I’ve formatted the cells in column A to Text to see if that effects it and
it doesn’t seem to.