Share via

Multiplying

Mary Joyce KUIJT 0 Reputation points
2026-03-09T14:44:26.73+00:00

How do i multiply a whole number by a decimal number from a different column for example in cell C1 there is 1 and in C2 there is 70.00 and I want the answer to appear in C3. Many thanks!

Microsoft 365 and Office | Excel | Other | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. DaveM121 891K Reputation points Independent Advisor
    2026-03-09T15:20:00.1333333+00:00

    The correct formula is = C1 * C2

    If you see an error when you put that formula in cell C3, then either or both cells C1 and C2 is not formatted as a number.

    Right click those cells and select 'Format Cell' and ensure the cells are set as a number format.

    Was this answer helpful?

  2. Mary Joyce KUIJT 0 Reputation points
    2026-03-09T14:46:27.6833333+00:00

    I have tried this but unfortunately I keep getting #VALUE! error message

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.