A formula can only return a result to the cell it is in. It cannot do
anything else, including affecting other cells.

You could have a formula in the other cell referencing the cell you're
interested in. And you could numer format the primary cell so that it
doesn't display anything (use the ;;; custom number format).

--
Jim Rech
Excel MVP
"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!!!