Hi,
Lets say i have a value in cell A1 of £.45236 and in cell A2 i want to add 50% to the value of A1 and round up to just 2 decimal places in order to get a sensible sale price.
How do i do this please?
[Solved] Help With A Formula
[Solved] Help With A Formula
Last edited by zooropa on Wed Sep 27, 2017 5:06 am, edited 2 times in total.
open office 4.1.3 on windows 7 pro
Re: Help With A Formula
The formula in A2 would be
Code: Select all
=ROUNDUP(A1*1.5;2)
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.