price increase to always end in 9, i.e. 1.99

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

Guest

i increase a product price by any given percentage. i want the answer to
round up so that it always ends in 9 i.e. the resultant increase is $1.45, i
want excel to print on my spread sheet $1.49.
 
Hi Frank,

put your original value into A1 and your percentage of increase into B1.
Then
=CEILING(A1*(1+B1%),0.1)-0.01
will give you the intended result (I hope).

HTH,
Bernd
 

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

How to increase all prices in price sheet by certain percent? 6
Need to increase price by % and rounding up and down 5
how do i increase the value of numbers in a column by a percentage 5
Percentage Increase 13
Distribution of capital contribution 4
Need Macro... 8
Conditional Formatting - Increases/Decreases 4
annual increases in price lists 1

Back
Top