Software

Ask something
Discussion Locked

Excel

0 helpful
2 replies

by akramsaudi

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

1.Formula output in a different cell
2. Is there any "Goto" function in excel

2 replies

by charliespencer

1. Why not enter the formula in the cell where you want the results? Alternatively, set the cell where you want the results equal to the cell containing the formula.

2. The CELL, OFFSET, or INDEX functions might fit you need. There's a 'Go To' menu option, which tells me there must be a Visual Basic equivalent.

by tobif

1. Excel works this way: what you see is the result of the formula in each cell (filtered through the cell format).
It is possible, though, to create a VBA macro, which will calculate something and write the result into a cell.
But, what are you trying to do?

2. What do you mean with GOTO?
Try looking up "HYPERLINK" in Excel help.
(By the way, you didn't tell us which version of Excel you're using.)

This discussion is closed to new replies.