Forum Discussion
likefatmike
Aug 26, 2020Copper Contributor
How to use if function with formula and round up or round down?
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 ...
HansVogelaar
Aug 26, 2020MVP
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))