Fri, 13 Apr 2007 17:50:03 -0700 from Dave Plyer
:
I add a series of prices. Regardless of the last digit in the sum, I want to
make the digit a 9. For example, the calculated sum of prices is $5.00. I
want $5.09 displayed. If the sum is $5.87, I want $5.89 displayed. Help,
please.
Assuming that the sum is in A20, I believe this formula would work:
=FLOOR(A20,.1)+.09
The FLOOR function chops off any pennies or nickels, and the +.09
adds the ending 9 that you want.
--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/