Return value in non-blank cell
 

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

Return value in non-blank cell
 

Maybe this:

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

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

--
Biff
Microsoft Excel MVP


"DebbieV" wrote in message
...
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

Return value in non-blank cell
 

Thanks Biff!

On Jun 4, 3:15*pm, "T. Valko" wrote:
Maybe this:

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

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

--
Biff
Microsoft Excel MVP

"DebbieV" wrote in message

...



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- Hide quoted text -

- Show quoted text -

Return value in non-blank cell
 

You're welcome!

--
Biff
Microsoft Excel MVP


"DebbieV" wrote in message
...
Thanks Biff!

On Jun 4, 3:15 pm, "T. Valko" wrote:
Maybe this:

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

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

--
Biff
Microsoft Excel MVP

"DebbieV" wrote in message

...



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- Hide quoted text -

- Show quoted text -