Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ROUND CENTS TO EITHER 49 OR 99 AMOUNTS
We manage prices of thousands of items that are especially volatile
currently. We want to round all cents <.49 as .49 and .50 as .99. As the cell contents are already a formula result, I'd like to "tack on" something else, if possible, rather than adding another column. I've reviewed the current "rounding" topics and can't quite find the working of conditionals.. Thanks All from a new participant! -- TENNISPLAYER |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round a number in nested function | Excel Worksheet Functions | |||
Round whole numbers up and down | Excel Discussion (Misc queries) | |||
I am trying to round up to the nearest 25 cents | New Users to Excel | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Amount or Numbers in Words | New Users to Excel |