Forum Discussion
Steph_is_confused
Dec 22, 2018Copper Contributor
How to mark up to the next nearest dollar minus $0.02?
I am trying to create a markup price list and I would like to be able to round the answers up to the whole dollar amount minus $0.02. I have already used =(B1*.10)+B1 to get a 10% markup answer of $...
SergeiBaklan
Dec 22, 2018Diamond Contributor
It's like
=ROUNDUP(B1*1.1,0)-0.02