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