What to combine this formula with ROUNDUP but want ROUNDUP on on the items greater than 20. I can do two different cells but trying to make this just one formula and in one cell.
=IF(D2<20,D2*1,IF(D2>20,D2*0.9))
=ROUNDUP(D2*0.9,0)-0.01
Thanks\
Jeff S
Bookmarks