How to use if function with formula and round up or round down?

%3CLINGO-SUB%20id%3D%22lingo-sub-1612843%22%20slang%3D%22en-US%22%3EHow%20to%20use%20if%20function%20with%20formula%20and%20round%20up%20or%20round%20down%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612843%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20how%20can%20I%20use%20if%20function%20with%20a%20formula%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20say%20on%20column%20A%20I%20have%3A%3C%2FP%3E%3CP%3EA1%3D15%2C000%3C%2FP%3E%3CP%3EA2%3D20%2C000%3C%2FP%3E%3CP%3Eand%20I%20want%20to%20make%20on%20column%20B%3A%3C%2FP%3E%3CP%3Eif%20A%20less%20than%2016%2C000%20then%20I%20want%20to%20divide%20it%20by%20750%20and%20divide%20again%20by%2010%20and%20round%20it%20up%2C%20but%20if%20A%20is%20more%20than%2016%2C000%20then%20I%20want%20to%20divide%20it%20by%20750%20and%20again%20by%2010%20and%20round%20it%20down.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20this%20but%20not%20functioning.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1612871%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20use%20if%20function%20with%20formula%20and%20round%20up%20or%20round%20down%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612871%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F771450%22%20target%3D%22_blank%22%3E%40likefatmike%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20want%20to%20round%20up%20or%20down%20to%20the%20nearest%20whole%20number%3F%20If%20so%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(A1%26lt%3B16000%2CROUNDUP(A1%2F7500%2C0)%2CROUNDDOWN(A1%2F7500%2C0))%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, how can I use if function with a formula?

 

Let say on column A I have:

A1=15,000

A2=20,000

and I want to make on column B:

if A less than 16,000 then I want to divide it by 750 and divide again by 10 and round it up, but if A is more than 16,000 then I want to divide it by 750 and again by 10 and round it down.

 

I tried this but not functioning.

 

 

 

1 Reply

@likefatmike 

Do you want to round up or down to the nearest whole number? If so:

 

=IF(A1<16000,ROUNDUP(A1/7500,0),ROUNDDOWN(A1/7500,0))