Results 1 to 18 of 18

Distribute automatically and equitly on EXCEL, in a certain number of cells, the result o

Threaded View

  1. #1
    Registered User
    Join Date
    05-03-2023
    Location
    Panama
    MS-Off Ver
    2019
    Posts
    10

    Distribute automatically and equitly on EXCEL, in a certain number of cells, the result o

    Ok this is my problem.



    I have the an total shipping cost( in this example 14.6) that normallys is a decimal number. This number have to be divide by the quantity of products that cames in a box( in this example 6). Giving a result of 2.433333



    I have to complete the Shipping cost column equally with the result already mentioned. But by only taking into account the rounded number 2.43 (because we are talking about money) it leaves me out the decimal number 0.02, which in this case could not leave out since we are talking about money.



    Therefore the sum of the shipping cost gives me 14.58 and not 14.60



    What would be the formula that I should implement to solve this problem?
    Attached Files Attached Files
    Last edited by memo08; 05-04-2023 at 01:01 AM. Reason: [SOLVED]

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Distribute number in one cell evenly across 5 other cells (round up if necessary)
    By b1ke in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-20-2022, 01:19 PM
  2. Distribute number across cells
    By pchugh in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-13-2019, 04:31 AM
  3. [SOLVED] distribute number on excel cell according to value
    By mazan2010 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-05-2017, 12:12 PM
  4. Replies: 7
    Last Post: 01-09-2016, 04:59 PM
  5. Evenly distribute a number across several cells
    By gbursson in forum Excel General
    Replies: 2
    Last Post: 02-18-2015, 05:51 AM
  6. [SOLVED] Distribute contents of a cell into other cells according to number of characters
    By Sacharny in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-14-2013, 10:38 AM
  7. Macro to Divide a Data in Cells and Distribute to X number of Columns
    By paul.serrato in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2013, 12:01 AM

Tags for this Thread

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