Thread
:
multiple and round
View Single Post
#
3
Bob Phillips
Posts: n/a
Is this any good
=ROUND(ROUND(A1*11,0)/11,2)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Heather Gilroy" <Heather
wrote in message
...
I need to take the (variable) cost price times 1.67 (fixed) and then have
the
result round (up or down) to the nearest 9th.
Example
cost 1.27 x 1.67 = 2.1209
rounded result = 2.09
Please Help! Thanks!
Reply With Quote