Hi,

In short no because formula cannot push values out they can only pull values
in. You could do it with another formula in the 'other' cell or with VB but
more detail is required
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Bib" wrote:

I would like to add the "if" formula into one cell but obtain the results in
another one. is this possible?