I need to populate the contents of one cell (may be date or numerical) to
other cell(s) depending on whether a condition is met. Is there a way to use
one of the Excel Functions to test if there is content in a given cell and
then return just the content of another cell? If there is no content in the
tested cell (cell is empty/blank), I would want no results to move to testing
cell (testing cell needs to remain blank). In addition, would this same
Function be capable of returning the cell content if in one instance, it was
a Date and another it was Numerical?

Any help would/will be greatly appreciated.

SHD

--
SHD

try something like in c1
=if(len(a1)1,b1,"")

--
Don Guillett
SalesAid Software

"YellowBird" wrote in message
...
I need to populate the contents of one cell (may be date or numerical) to
other cell(s) depending on whether a condition is met. Is there a way to
use
one of the Excel Functions to test if there is content in a given cell and
then return just the content of another cell? If there is no content in
the
tested cell (cell is empty/blank), I would want no results to move to
testing
cell (testing cell needs to remain blank). In addition, would this same
Function be capable of returning the cell content if in one instance, it
was
a Date and another it was Numerical?

Any help would/will be greatly appreciated.

SHD

--
SHD

:=IF(A1="","",B1)

Will return the contents of B1 if A1 is not blank,

HTH
--
AP

"YellowBird" a écrit dans le message
de ...
I need to populate the contents of one cell (may be date or numerical) to
other cell(s) depending on whether a condition is met. Is there a way to
use
one of the Excel Functions to test if there is content in a given cell and
then return just the content of another cell? If there is no content in
the
tested cell (cell is empty/blank), I would want no results to move to
testing
cell (testing cell needs to remain blank). In addition, would this same
Function be capable of returning the cell content if in one instance, it
was
a Date and another it was Numerical?

Any help would/will be greatly appreciated.

SHD

--
SHD

Ardus,

Thanks for your prompt reply. It is appreciated.

This works fine if the "tested" cell has an entry. In the event that the
"tested" cell is blank, it puts a blank in the "testing" cell. This then
causes an error since in the one instance, I am subtracting this result,
which is a Date, from another Date. Subtracting a blank "" from a Date
returns an unwanted result. Even a result of 0 would not work properly. I
would then receive an unwanted result in my calculation of subtracting one
Date from 0.

Is there a way to "test" the contents, which again may be either a Date or
Number, and if the result shows the cell is has neither, return no answer at
all? The result would need to be a cell with nothing in it.

Thanks again for your help.
--
SHD


"Ardus Petus" wrote:

:=IF(A1="","",B1)

Will return the contents of B1 if A1 is not blank,

HTH
--
AP

"YellowBird" a écrit dans le message
de ...
I need to populate the contents of one cell (may be date or numerical) to
other cell(s) depending on whether a condition is met. Is there a way to
use
one of the Excel Functions to test if there is content in a given cell and
then return just the content of another cell? If there is no content in
the
tested cell (cell is empty/blank), I would want no results to move to
testing
cell (testing cell needs to remain blank). In addition, would this same
Function be capable of returning the cell content if in one instance, it
was
a Date and another it was Numerical?

Any help would/will be greatly appreciated.

SHD

--
SHD

What do you want in the "testing" cell. If not blank nor 0, what else?

Regards,
--
AP

"YellowBird" a écrit dans le message
de ...
Ardus,

Thanks for your prompt reply. It is appreciated.

This works fine if the "tested" cell has an entry. In the event that the
"tested" cell is blank, it puts a blank in the "testing" cell. This then
causes an error since in the one instance, I am subtracting this result,
which is a Date, from another Date. Subtracting a blank "" from a Date
returns an unwanted result. Even a result of 0 would not work properly.
I
would then receive an unwanted result in my calculation of subtracting one
Date from 0.

Is there a way to "test" the contents, which again may be either a Date or
Number, and if the result shows the cell is has neither, return no answer
at
all? The result would need to be a cell with nothing in it.

Thanks again for your help.
--
SHD


"Ardus Petus" wrote:

:=IF(A1="","",B1)

Will return the contents of B1 if A1 is not blank,

HTH
--
AP

"YellowBird" a écrit dans le
message
de ...
I need to populate the contents of one cell (may be date or numerical)
to
other cell(s) depending on whether a condition is met. Is there a way
to
use
one of the Excel Functions to test if there is content in a given cell
and
then return just the content of another cell? If there is no content
in
the
tested cell (cell is empty/blank), I would want no results to move to
testing
cell (testing cell needs to remain blank). In addition, would this
same
Function be capable of returning the cell content if in one instance,
it
was
a Date and another it was Numerical?

Any help would/will be greatly appreciated.

SHD

--
SHD

Ardus,

The intent is to have a Date moved from cell A30 (hypothetical) to cell J30
(again, hypothetical) if the "testing" cell L30 finds a number in the
€œtested€� cell F30. If there is a number, I want the Date from A30 to
populate to the €œtesting€� cell L30. However, if there is not a number in
F30, I do not want anything to be populated to L30. A blank €œ€� or 0 results
in another calculating cell returning an error when it tries to subtract its
already calculated Date result from a blank or 0, which Excel doesn't like.

I hope that this is not too confusing.

Thanks for any help.

--
SHD


"Ardus Petus" wrote:

What do you want in the "testing" cell. If not blank nor 0, what else?

Regards,
--
AP

"YellowBird" a écrit dans le message
de ...
Ardus,

Thanks for your prompt reply. It is appreciated.

This works fine if the "tested" cell has an entry. In the event that the
"tested" cell is blank, it puts a blank in the "testing" cell. This then
causes an error since in the one instance, I am subtracting this result,
which is a Date, from another Date. Subtracting a blank "" from a Date
returns an unwanted result. Even a result of 0 would not work properly.
I
would then receive an unwanted result in my calculation of subtracting one
Date from 0.

Is there a way to "test" the contents, which again may be either a Date or
Number, and if the result shows the cell is has neither, return no answer
at
all? The result would need to be a cell with nothing in it.

Thanks again for your help.
--
SHD


"Ardus Petus" wrote:

:=IF(A1="","",B1)

Will return the contents of B1 if A1 is not blank,

HTH
--
AP

"YellowBird" a écrit dans le
message
de ...
I need to populate the contents of one cell (may be date or numerical)
to
other cell(s) depending on whether a condition is met. Is there a way
to
use
one of the Excel Functions to test if there is content in a given cell
and
then return just the content of another cell? If there is no content
in
the
tested cell (cell is empty/blank), I would want no results to move to
testing
cell (testing cell needs to remain blank). In addition, would this
same
Function be capable of returning the cell content if in one instance,
it
was
a Date and another it was Numerical?

Any help would/will be greatly appreciated.

SHD

--
SHD