Results 1 to 9 of 9

Multiplying odd numbers by percentages to total to original number

Threaded View

leepea42 Multiplying odd numbers by... 01-04-2013, 04:52 PM
dilipandey Re: Multiplying odd numbers... 01-05-2013, 04:15 AM
leepea42 Re: Multiplying odd numbers... 01-07-2013, 12:43 PM
dilipandey Re: Multiplying odd numbers... 01-07-2013, 02:17 PM
leepea42 Re: Multiplying odd numbers... 01-07-2013, 03:55 PM
dilipandey Re: Multiplying odd numbers... 01-08-2013, 01:06 AM
FDibbins Re: Multiplying odd numbers... 01-08-2013, 01:32 AM
dredwolf Re: Multiplying odd numbers... 01-08-2013, 01:46 AM
vlady Re: Multiplying odd numbers... 01-08-2013, 02:22 AM
  1. #8
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Multiplying odd numbers by percentages to total to original number

    Also, you have to remember, displayed value is rounded to closest level of display formatting, usually a .*5 or higher gets DISPLAYED as next highest value(ie- 0.0005, rounded to 3 decimals will display as 0.001, however...the value is still 0.0005, so mathematically, they are the same, just visually they change...unless you force a round off error using the round(several) functions...
    Last edited by dredwolf; 01-08-2013 at 01:49 AM.
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1