display results of formula in different cell

S

ScheduleQueen

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!!!
 
J

Jim Rech

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).
 
T

Tom Ogilvy

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 said:
I need to display the results of an IF formula in a cell other that the
Click to expand...
one where the formula is located. Can I do that? How/ Thanks!!!
 
A

Anders Silven

ScheduleQueen,

See your other post as well, and please don't multipost.

Regards
Anders Silven

ScheduleQueen said:
I need to display the results of an IF formula in a cell other that the one
Click to expand...
where the formula is located. Can I do that? How/ Thanks!!!
 
Top