Share via

how do i set up the formula to multiply?

Anonymous
2023-06-22T21:31:58+00:00

I want all amounts in column A to show up in column B as multiplied by 3.

Windows for home | Windows 11 | Settings

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rodrigo Queiroz 77,250 Reputation points Independent Advisor
    2023-06-22T22:08:58+00:00

    Hi Nancy,

    I'm Rodrigo and I'll help you.

    To make the second column multiply the first, insert this formula on the first value of the second column:

    =A1*3

    A1 is the first value of the first column (change to the cell of your first column)

    Drag from the corner of the first value of the second collum to the last to apply on the other cells.

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-06-22T21:54:20+00:00

    And you are using Excel, which is not part of Win and supported under Office, maybe the book, "Excel for Dummies"

    0 comments