Forum Discussion

Trent Udelhoven's avatar
Trent Udelhoven
Copper Contributor
Feb 08, 2018

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!

Resources