Need to create bins of "product weight"

**deepakkala04** · 08-08-2016, 04:19 AM

Need to create bins of "product weight" in excel such that any actual weight like:- "4.235 Kg" gets rounded-off as 4.5Kg.
I have tried using MROUND using multiple as 0.5 but this seems to round off to nearest multiple of 0.5 and hence 4.235 appears as 4 whereas I want it to be rounded to 4.5 if above 4 and 5 if above 4.5.
Please suggest some way

**Special-K** · 08-08-2016, 04:38 AM

Does this work?

=CEILING(A1,0.5)

Need to create bins of "product weight"

LinkBack

Thread Tools

Rate This Thread

Display

Need to create bins of "product weight"

Re: Need to create bins of "product weight"

Thread Information

Users Browsing this Thread

Similar Threads

x y scatter plot with "bins"

create text string: "NOT "[b2value]", NOT "[b3value]", ..., NOT "[b600value]"

Help to create a string of drop-down "options" that together define a unique product/Price

Create a Command Button to "Save As" and "Close" an Excel Workbook

Seperating "colour" and "size" values into seperate columns from the "product name"

create a "live" input table for product prices from a list of automatic unique values

[SOLVED] create links to check boxes marked "good" fair"and "bad"

Bookmarks

Bookmarks

Posting Permissions