You can link that cell to the original. Assume the formula is in A1 and you
want to see the results in F1 as well as A1

=A1 in F1 would do that.

However, A1 would also display the result. You could give it a custom
number format like ;;;

if you don't want to see anything in A1 (but the value is still there).

--
regards,
Tom Ogilvy


"ScheduleQueen" wrote in message
...
I need to display the results of an IF formula in a cell other that the
one where the formula is located. Can I do that? How/ Thanks!!!