WI adopted a new sales tax of 5.5% (.055). When I calculate a list of sales items INDIVIDUALLY for tax, it multiples by .055 and then rounds up to two decimal places, i.e. $1.00 = 6 cents tax. HOWEVER when I ADD up the COLUMN of calculated taxes, it adds up the UNROUNDED value, i.e. $0.055 cents on the dollar, NOT the rounded up value in the cell. I need to add up the rounded up values.
Go to Options=>Advance=>formulas=>when calculating this workbook=> and check the box
Set precision as displayed.
Last edited by ImranBhatti; 02-08-2017 at 02:56 PM. Reason: For further guidlines
Teach me Excel VBA
I am working with Excel 2007 and under Excel Options I cannot find this box. It certainly sounds like the answer to my problem if I could only find it. What tab is it under: Formulas? Advanced?
O..lemme check for Excel 2007 (I am using 2016)
See post#2 I have edited that
I just found it under Advanced! Sorry for my impatience! thank you for your help!
You are welcome. Glad to have helped.
If your problem is solved please mark the thread as solved.
I have not figured out where to mark "Solved"???
Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks