Microsoft Excel 3

[damo74]

Folks,

I'm trying to round off figures in microsoft excel but don't know how to go about it. For instance, round off 2387 to 2400. Has anyone any ideas how?

 

[STR04]

CELL A2 = 2387

=ROUND(A2,2-LEN(INT(A2)))= 2400

This can be found under excel's help menu.

 

[HgTX]

For future reference, try forum770.

Hg

Eng-Tips policies: faq731-376

 

[PEStructural]

Or you can try this:

CELL A2 = 2387

=ROUND(A2,-2)

or if you want it to only roundup:

=ROUNDUP(A2,-2)

Hope this helps.

 

[damo74]

Thanks guys,

Sorted.