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
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
=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