Rounded price markup

Discuss the spreadsheet application
Post Reply
igabc
Posts: 14
Joined: Wed Jul 23, 2014 11:57 pm

Rounded price markup

Post by igabc »

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
Top
FJCC
Moderator
Posts: 9280
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Rounded price markup

Post by FJCC »

This formula returns 830.

Code: Select all

=ROUND(756*1.1;-1)
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Top
Post Reply

Return to “Calc”