formulas for round numbers up to next dolllar

D

dewberryz

I need to create a worksheet for work. I need to take original cost of
merchandise, divide by 3, then multiply that amount by 8. The final amount
needs to be taken to the next whole number. Here is a example of what I need
to do.

$245 / 3 = $81.67 X 8 = $653.33

the final amount needs to be $654.00
 
W

William

Hi

=ROUNDUP(245/3*8,0)

--
XL2002
Regards

William

[email protected]

| I need to create a worksheet for work. I need to take original cost of
| merchandise, divide by 3, then multiply that amount by 8. The final
amount
| needs to be taken to the next whole number. Here is a example of what I
need
| to do.
|
| $245 / 3 = $81.67 X 8 = $653.33
|
| the final amount needs to be $654.00
|
 
Top