Rounded price markup

Discuss the spreadsheet application

Rounded price markup

Postby igabc » Fri Dec 13, 2019 8:13 pm

Hello and happy holidays!

I'd like to calculate a price markup based on a percentage (10%) but rounded.

=A1*1,1

A1 = 756

Result = 831.6

I'd like 831 (no decimals) or, even better, 830

thanks!
G
Open Office 4.1.0
igabc
 
Posts: 14
Joined: Wed Jul 23, 2014 11:57 pm

Re: Rounded price markup

Postby FJCC » Fri Dec 13, 2019 8:32 pm

This formula returns 830.
Code: Select all   Expand viewCollapse view
=ROUND(756*1.1;-1)
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7747
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA


Return to Calc

Who is online

Users browsing this forum: No registered users and 8 guests