SOLVED

If Function that results in formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-153813%22%20slang%3D%22en-US%22%3EIf%20Function%20that%20results%20in%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-153813%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20am%20trying%20to%20set%20up%20an%20If%20function%20that%20will%20perform%20rounding%20for%20me.%26nbsp%3B%20It%20will%20look%20at%20a%20specific%20cell%20that%20will%20either%20be%20a%20negative%20or%20positive%20number.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20that%20number%20is%20positive%20I%20need%20it%20to%20round%20down%20to%20the%20nearest%2025%2C000%20increment.%3C%2FP%3E%0A%3CP%3EFor%20example%20if%20the%20cell%20is%201%2C235%2C135%20it%20would%20round%20to%201%2C225%2C000.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20that%20number%20is%20negative%20I%20need%20it%20to%20round%20up%20to%20the%20nearest%2025%2C000.00%3C%2FP%3E%0A%3CP%3EFor%20example%20if%20the%20cell%20is%20(1%2C235%2C135)%20it%20would%20round%20to%20(1%2C250%2C000)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20this%20possible%3F%20let%20me%20know%20if%20you%20have%20any%20questions.%3C%2FP%3E%0A%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-153813%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-153843%22%20slang%3D%22en-US%22%3ERe%3A%20If%20Function%20that%20results%20in%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-153843%22%20slang%3D%22en-US%22%3EThis%20worked!%20awesome%20thanks!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-153835%22%20slang%3D%22en-US%22%3ERe%3A%20If%20Function%20that%20results%20in%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-153835%22%20slang%3D%22en-US%22%3E%3CP%3ECould%20be%3C%2FP%3E%0A%3CPRE%3E%3DFLOOR(%26lt%3Bcell%20value%26gt%3B%2C25000)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor

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!

2 Replies
best response confirmed by Trent Udelhoven (New Contributor)
Solution

Could be

=FLOOR(<cell value>,25000)
This worked! awesome thanks!