LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Need help with rounding percentages

I'm trying to figure federal, state and local tax based on the sales amount.
My problem is sometimes Excel rounds up and sometimes it rounds down. I've
tried the round, roundup, and rounddown functions and neither of them work
the way I need them to. Is there any other way to get the rounding correctly.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need a formula with rounding up & rounding down to the nearest . Tony Kay Excel Worksheet Functions 3 May 29th 07 11:13 PM
Rounding percentages problem need a solution for jimtmcdaniels Excel Discussion (Misc queries) 2 April 27th 06 08:22 AM
Percentages Hotpants0063 Excel Worksheet Functions 4 April 10th 06 10:30 PM
Bug in Rounding percentages of Bar of Pie chart Murat Gulbay Charts and Charting in Excel 4 August 23rd 05 05:12 PM
percentages johnsmith Excel Discussion (Misc queries) 4 August 16th 05 07:17 PM


All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"