Identify Blank cells in XL & return value

  • Thread starter Thread starter Dom
  • Start date Start date
D

Dom

Dear all,
The ISBLANK function inserted ito one cell identifies
whether another cell is blank and returns a value of TRUE
or FALSE. Is there a way of doing the same job but
returning a user-specified value (e.g. a numerical value)
according to what the result is?
Thanks....
 
Dominic,

=IF(ISBLANK(A1)=TRUE,5,6)

Use whatever values or text (enclosed in ""'s) that you wish.


PC
 
Back
Top