close



Try the ROUNDM function.--
nsv
------------------------------------------------------------------------
nsv's Profile: www.excelforum.com/member.php...oamp;userid=26500
View this thread: www.excelforum.com/showthread...hreadid=509329On Tue, 7 Feb 2006 05:45:15 -0800, beti10 gt;
wrote:

=ROUND(A1/500,0)*500--ron

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

    software

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