Error in Multiplication Formula in MS EXCEL

Asked By sarmadmunir 30 points N/A Posted on - 04/01/2012

I have a worksheet that shows total hours and minutes worked, along with the hourly pay rate.

When I multiply these vales, I don't get the result I'm looking for.

What's wrong?

• Status: Open
• Question Views: 2334
• Answer Count: 2
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Sherin Viluel

Go To Solution

Answered By Tanok Bloran 80 points N/A #155105

Error in Multiplication Formula in MS EXCEL

In doing multiplication on Excel, you must use the symbol asterisk or * instead of “x”.

Also, the equal sign should be at the start of the formula instead of after.

Try the following to create a table with multiplication formula for your Excel spreadsheet:

1. Click into the cell you would like to formula to be
2. Click on the formula bar which is found at the top of Excel
3. Type the following formula: = B15 * C15 wherein the B is the letter of the columns you’d like to multiply, and 15 is the number of row where the item you’d like to multiply is placed
4. Hit enter

For further assistance or reference you may go here to or check this link.

About Tanok Bloran

Questions
2

Answers
315

Best Answers
100

• Vote Up 0 Vote Down

• Posted on - 04/01/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Sherin Viluel 0 points N/A #155106

Error in Multiplication Formula in MS EXCEL

You can arrive at a solution in this way.

We will just take an example,

When the time is 1 hour and 30 minutes (assume that you have mentioned it as 1.30) and the hourly rate in 100 the total value should be 150.

However, in you excel you do not get that result (150) instead you get the result as 130 as follows.

 

The reason for the above result is, excel does not understand the .30 as 30 minutes or as half an hour. Instead it will understand it as 30 out of hundred. (30/100)

In order to get the result that you expect I will give you a formula that you can apply on the result column.

The formula is,

=(ROUNDDOWN(B2,0)+(B2-ROUNDDOWN(B2,0))/60*100)*C2

Important: you should apply this formula to Cell D2 if the hours and minute is cell B2 and the hourly rate is in cell C2.However, you can drag it down to any rows which you want.

Then you will be able to get the result you expected as shown in the following image.

About Sherin Viluel

Questions
0

Answers
50

Best Answers
37

• Vote Up 0 Vote Down

• Posted on - 06/28/2012
• Question Category: MS Excel