Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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