Hello -
I know this sounds strange, but I am looking for a way to condition data in spreadsheet cells to round down at 5 and round up at 6.
Example:
$2.245 would be $2.24
AND
$2.246 would be $2.25.
Is this even possible as it seems all of rounding functions in Excel and based on traditional rounding rules.
Thank you very much for any help!
I know this sounds strange, but I am looking for a way to condition data in spreadsheet cells to round down at 5 and round up at 6.
Example:
$2.245 would be $2.24
AND
$2.246 would be $2.25.
Is this even possible as it seems all of rounding functions in Excel and based on traditional rounding rules.
Thank you very much for any help!