close

I have say =sum(E1 G3)
E1 = $10.00
G3 = 8
The cell I put this formula in comes up (2 or 3) cents off.
This does not happen all the time but off amp; on.www.mcgimpsey.com/excel/pennyoff.html--
Kind regards,

Niek Otten

quot;Kickstartquot; gt; wrote in message ...
gt;I have say =sum(E1 G3)
gt; E1 = $10.00
gt; G3 = 8
gt; The cell I put this formula in comes up (2 or 3) cents off.
gt; This does not happen all the time but off amp; on.
gt;
Sounds like one of the cells contains the small cents values but they don't
show because of formatting.....

hth
Vaya con Dios,
Chuck, CABGx3
quot;Kickstartquot; wrote:

gt; I have say =sum(E1 G3)
gt; E1 = $10.00
gt; G3 = 8
gt; The cell I put this formula in comes up (2 or 3) cents off.
gt; This does not happen all the time but off amp; on.
gt;

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

    software

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