close

how do I convert numbers to the nearest 1000


=round(a1,-3)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=509613One way is to use MRound:

=Mround(a1,1000)

This requires the Analysis ToolPak to be installed.

Or:

=int(a1/1000)*1000

--
Regards,
Fredquot;Brianquot; gt; wrote in message
...
gt; how do I convert numbers to the nearest 1000

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()