how to round up a number in a cell with a formula?

[barneyboy]

A B C D
1000 269 4 00003.7

Hi .. in the above row I have A divided by B to give C formatted to 'no decimal points'.
In Column D I have the formula: =TEXT(C1,"00000.0"). However, I would like cell D1 to show: 00004.0 instead of 00003.7.

I'd appreciate any help on this. Many thanks in advance.

Barneyboy

 

[MrKowz]

Two ways you can do this. Use either:

1. In C1, replace the formula with:
   =ROUND(A1/B1,0)
2. Or in D1, replace the formula with:
   =TEXT(ROUND(C1,0),"00000.0")

 

[barneyboy]

Many thanks, MrKowz .. exactly what I wanted.

Cheers

 

[MrKowz]

Many thanks, MrKowz .. exactly what I wanted.

Cheers

Glad it is what you needed. Thank you for the feedback.