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

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



Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies