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

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

Excel formula, sum the value cell and if empty cell left blank 0
Returning Value of Next Non-Blank Cell in Column 2
First non empty cell and non blank cell 6
Return value of non-blank cell 2
Return a value to a cell that is blank 2
Excel 2003 - Skip a cell 5
Return value of a non blank cell 10
Find previous number and find next number in column 4

Top