ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Row of numbers not adding correctly (https://www.excelbanter.com/excel-discussion-misc-queries/138223-row-numbers-not-adding-correctly.html)

Dale

Row of numbers not adding correctly
 
Nick,

Thanks for your help. The second option worked well for me. I am
interested in the Round function. How might I accomplish that? Thanks again!

Thanks for your help.

Dave Peterson

Row of numbers not adding correctly
 
You may want to read Excel's help for =round().

Then post back with your questions.

Dale wrote:

Nick,

Thanks for your help. The second option worked well for me. I am
interested in the Round function. How might I accomplish that? Thanks again!

Thanks for your help.


--

Dave Peterson

R1C1

Row of numbers not adding correctly
 
Rounded to 2 decimals.

=ROUND(A50/1.06)*.06,2)

Rounded to a whole number.

=ROUND(A50/1.06)*.06,0)


Regards,

Alan


"Dale" wrote in message
...
Nick,

Thanks for your help. The second option worked well for me. I am
interested in the Round function. How might I accomplish that? Thanks
again!

Thanks for your help.





All times are GMT +1. The time now is 01:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com