Identify Blank cells in XL & return value

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....
 
P

Paul Corrado

Dominic,

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

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


PC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Index Match & #values 0
Evaluate Multiple Cells for any Value 1
Hide columns based on row values 2
formula finds values in apparently blank cells 1
Conditional formatting based on formula cell 4
Identifying non-returning formula (blank Cell) 9
Need help finding a substring in a array of strings. 1

Top