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

Highlighted
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
Highlighted

@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))