# Equation is wrong????????

#### craigwojo

##### Board Regular
Working with Excel 2003.

Creating a spreadsheet for percentages and pricing.

Cell D4 is input "127"
I have cell M4 to get 80% of D4. My input function is =SUM(D4)*0.8
The equation of M4 is 102. Which is correct answer for 80% of 127.

In cell N4 I need to use the 102 answer in M4 to be multiplied by \$20.00. The answer I am getting is \$2032.00 not \$2040.00 which it should be.

What is wrong with the way I am set up in this spreadsheet.

Thank you and God bless,
Craig

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
80% of 127 is not exactly 102.

You can round the result to 102 by using this formula in cell M4:

=ROUND(D4*0.8,0)

Looks like rounding to me. Is it exactly 102?? I suspect not.

127*0.8 is 101.6, not 102

You probably have M4 formatted to 0 decimal places, so it appears to be rouned to 102.
But any formula referring to M4 sees the real value of 101.6
And 101.6*20 = 2032

Thank you so much.

Replies
3
Views
300
Replies
4
Views
716
Replies
1
Views
545
Replies
0
Views
831
Replies
1
Views
768

1,203,759
Messages
6,057,191
Members
444,913
Latest member
ILGSE

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back