rounding up and down formulas
That formula will *round down* an integer and a decimal = to 0.5
A1 = 10
A1 = 1.5
Formula result = 9.99
Formula result = 1.49
--
Biff
Microsoft Excel MVP
"pdberger" wrote in message
...
Kris --
Here's one approach:
A B
1 number =CEILING(A1,0.5)-0.01
HTH
"kris" wrote:
I am creating a retail price for our items. Problem is that I want the
retail
price to end in either a .49 or .99. Example when I figure my retail
pricing
off my cost it may come out to $6.74 and I would like to have a formula
so
that it would automatically come out to $6.99 or if it was to $6.49 if is
was
a lower number. Thanks!
|