Return value in non-blank cell

D

DebbieV

Hi

I have dates in some cells and remainder blank in column A if I want
to return the value located in A3 in F3 how do only return a value if
it is a non-blank?

(I have done this before but memory is 'blank'!)

thanks
Debbie
 
T

T. Valko

Maybe this:

=IF(A3<>"",A3,"")

Which means: if A3 is not blank return the value of A3, otherwise return
blank.
 
D

DebbieV

Thanks Biff!

Maybe this:

=IF(A3<>"",A3,"")

Which means: if A3 is not blank return the value of A3, otherwise return
blank.

--
Biff
Microsoft Excel MVP









- Show quoted text -
Click to expand...
 
Top