Share via

How to insert a division function between two cells in Excel

Anonymous
2023-02-18T02:10:37+00:00

How do I insert a division function between two cells in Excel?

Microsoft 365 and Office | Excel | For home | Windows

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

Answer accepted by question author

  1. Anonymous
    2023-02-18T02:43:25+00:00

    Hello Jim A,

    Thanks for contacting us, my name is Akande and i'm glad to help with your question.

    To insert a division function between two cells in Excel, you can use the forward slash symbol (/) in a formula. Here are the steps:

    1. Click on the cell where you want to display the result of the division function.
    2. Type the equals sign (=) to start the formula.
    3. Click on the cell that contains the numerator (the number that will be divided).
    4. Type the forward slash (/) symbol.
    5. Click on the cell that contains the denominator (the number that will divide the numerator).
    6. Press Enter to complete the formula.

    For example, if you want to divide the value in cell A1 by the value in cell B1, you can enter the formula "=A1/B1" in a different cell.

    If you need to reference cells in a different worksheet, you can add the worksheet name before the cell references separated by an exclamation mark. For example, "=Sheet1! A1/Sheet2! B1".

    I hope this helps, Let me know if you have any other questions.

    Kind Regards, Akande.

    10+ people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-18T04:26:27+00:00

    Thanks Akande, as you see below the problem was with the sheet and when I changed to a new sheet everything worked as it should. Thanks again.

    Jim

    0 comments
  2. Anonymous
    2023-02-18T04:24:31+00:00

    Thanks Daniel

    I had had not done this for a while. I thought I knew how but could not get it to work. I thought something must have changed in the program. The directions you gave me were exactly the same as I was doing. Every time I hit enter to get the result, the cell below highlighted, and the formula was all I could see. I went to a knew work sheet and it all works perfectly just as I remembered. Thanks for your help. Much appreciated.

    Jim

    0 comments