Hi, how can I use if function with a formula?
Let say on column A I have:
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.
Do you want to round up or down to the nearest whole number? If so: