Rounding to .99 sum

0

How can I make a formula always round up to .99 no matter if it starts as .29 or .54 ect... example =L44*2.5 then what do I put to make it round up to .99 always?

L44=10.45

Answer
Discuss

Answers

0
Selected Answer
=TRUNC(A1)+0.99

A1 should be the cell that has the number that you want to "round" up. For your example, you would do something like this:

=TRUNC(L44*2.5)+0.99
Discuss

Discussion

That is awesome and solved my problem completely. Thank you so much for the help.
Karin (rep: 2) Aug 16, '16 at 2:20 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login