Thread
:
price increase to always end in 9, i.e. 1.99
View Single Post
#
2
Bernd Plumhoff
Posts: n/a
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
Reply With Quote