Forum Discussion
Trent Udelhoven
Feb 08, 2018Copper Contributor
If Function that results in formulas
Hello,
I am trying to set up an If function that will perform rounding for me. It will look at a specific cell that will either be a negative or positive number.
If that number is positive I need it to round down to the nearest 25,000 increment.
For example if the cell is 1,235,135 it would round to 1,225,000.
If that number is negative I need it to round up to the nearest 25,000.00
For example if the cell is (1,235,135) it would round to (1,250,000)
Is this possible? let me know if you have any questions.
Thanks!
Could be
=FLOOR(<cell value>,25000)
Could be
=FLOOR(<cell value>,25000)
- Trent UdelhovenCopper ContributorThis worked! awesome thanks!