ROUNDUP MONEY VALUE IN SAME CELL AS % INCREASE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to roundup a monetary value to the nearest £5 or £10.

e.g. In G7 I have the item buy in value of £119.14
H7 formula is =g7*17%+g7 which gives me a mark up cost at 17%

Is there a way to roundup the value in H7 to the nearest £5 or £10 without
placing the roundup formula in a different cell?

Thank you
 
Hi

Try
=CEILING(G7*(1+17%),5)
If you wanted to put your markup in another cell, say in A1 as 17% then
you could use
=CEILING(G7*(1+A1),5)

Changing the % value in A1 will automatically adjust your prices
 
Thats excellent, thank you all very much.

Roger Govier said:
Hi

Try
=CEILING(G7*(1+17%),5)
If you wanted to put your markup in another cell, say in A1 as 17% then
you could use
=CEILING(G7*(1+A1),5)

Changing the % value in A1 will automatically adjust your prices
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple Formula Help 4
using row number or column letters in formula 5
Rounding in Excel 2
ROundup 2
nested if statements using "AND" as well as "OR" 2
Using Roundup in an IF Statement 2
Count Unique With one Condition & No ROUNDUP 7
Nested Formulas v Named Formulas Any other solutions? 10

Back
Top