Aug 26 2020 12:28 AM
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.
Aug 26 2020 12:37 AM
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))