| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return value of a non blank cell | Excel Discussion (Misc queries) | |||
| I want to return the #VALUE! as a blank cell. | Excel Worksheet Functions | |||
| If cell blank return a blank | Excel Worksheet Functions | |||
| Return a value to a cell that is blank | Excel Discussion (Misc queries) | |||
| use IF to return a truly blank cell | Excel Discussion (Misc queries) | |||
Linear Mode
