numeric formatting limit digits
I have two numeric formulas that use price & percentage. However the results are quite long and I want to limit what it displays or round up. for example the results are like this: 24.369918699187%...
Forum Discussion
sorry for the confusion. So, yes the rounding works. However my question is this: I have a number: $2.5567. I do NOT want to round but I want to display and export it as $2.55 (so it is not automatically rounding up to $2.56 but just displaying & exporting the first two decimal places). I also have a percentage 30.5555%, I want to display & export to excel as 30% (again not rounding up to 31%), Is that possible to show the number like that without rounding?
I think you are looking for these types of formulas using Floor(x, y) with two arguments:
Floor([Price], 0.01)
Floor([Percentage], 0.01)