What formula can I use so that all numbers round up to the nearest .99 ending? 23.46 = 23.99
Thanks!
What formula can I use so that all numbers round up to the nearest .99 ending? 23.46 = 23.99
Thanks!
=VALUE(TRUNC(A1,0)&".99")Originally Posted by mj99
--Mark
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Mark-
Thanks very much....that worked perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks