Ask Your Question
3

How can I input several variables in a formula's reference cell and obtain the output from a different cell in Excel?

asked 2022-07-21 11:00:00 +0000

lalupa gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
2

answered 2023-02-07 07:00:00 +0000

woof gravatar image

You can use the formula bar in Excel to input several variables and obtain the output in a different cell. Here's an example:

Suppose you have three variables in cells A1, A2, and A3, and you want to calculate their sum and display the result in cell A4. You can use the following formula in the formula bar:

=SUM(A1:A3)

This formula adds the values in the range A1:A3 and displays the result in cell A4. You can change the values in cells A1, A2, and A3, and the result in cell A4 will automatically update.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2022-07-21 11:00:00 +0000

Seen: 12 times

Last updated: Feb 07 '23