| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
General Cell Data Verification and Copy...
I am looking for the function or combination of functions to do the
following... If cell A2 has no data in it (General Data) then cell F2 reflects the same (blank), however if cell A2 has some data in it for Ex: N 90-00-00 W the cell F2 would reflect this as well...I work great with numbers but text and text strings confuse me... Thank you, -- jgbadingerjr |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
General Cell Data Verification and Copy...
In F2 put this formula:
=If(A2="","",A2) This formula does as follows: If A2 is blank, F2 displays as blank. If A2 is not blank, F2 displays the contents of A2. HTH Otto "jgbadingerjr" wrote in message ... I am looking for the function or combination of functions to do the following... If cell A2 has no data in it (General Data) then cell F2 reflects the same (blank), however if cell A2 has some data in it for Ex: N 90-00-00 W the cell F2 would reflect this as well...I work great with numbers but text and text strings confuse me... Thank you, -- jgbadingerjr |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
General Cell Data Verification and Copy...
You might try a formula like the following in F2
=IF(ISBLANK(A2),"",A2) jgbadingerjr wrote: I am looking for the function or combination of functions to do the following... If cell A2 has no data in it (General Data) then cell F2 reflects the same (blank), however if cell A2 has some data in it for Ex: N 90-00-00 W the cell F2 would reflect this as well...I work great with numbers but text and text strings confuse me... Thank you, -- jgbadingerjr |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
General Cell Data Verification and Copy...
Thank you ...most helpful...
-- jgbadingerjr "jgbadingerjr" wrote: I am looking for the function or combination of functions to do the following... If cell A2 has no data in it (General Data) then cell F2 reflects the same (blank), however if cell A2 has some data in it for Ex: N 90-00-00 W the cell F2 would reflect this as well...I work great with numbers but text and text strings confuse me... Thank you, -- jgbadingerjr |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying the function contained within a cell to anouther cell. | Excel Worksheet Functions | |||
Linear Mode
