Question

How should the following formula be written: Multiply Cell A1 by 6, and divide that by 4?

Answer 1

Answer:

The formula in Excel to get the result is:

=(A1 * 6) / 4

or

=($A$1 * 6) / 4

Explanation:

The "$" (dollar) sign inserted into the cell reference makes the reference absolute. This means that, if this cell contents are copied and pasted into another cell, the cell reference A1 remains intact, otherwise the reference is not absolute and the cell reference will change in relation to the position of the cell into which the contents are copied.

Answer 2

The formula can be written as,

                                   =PRODUCT(A1,6)/4

For creating formulas in Excel,

• The Creation of the formula starts from the sign of '='.
• After the sign of '=', the rest of the formula can be written as usual.
• For the statement given,

                                            Multiply by cell A1 by 6

                                            Divide that by 4

       the numbers are first operated by the product function and then divided       by the sign '/'