Home

How to mark up to the next nearest dollar minus $0.02?

Steph_is_confused
Occasional Visitor

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 $1.10 and I would like to take that answer and round it up to $1.98, is there any way to do this?

1 Reply

It's like

=ROUNDUP(B1*1.1,0)-0.02

 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies