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 & on.
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 & on.
http://www.mcgimpsey.com/excel/pennyoff.html
--
Kind regards,
Niek Otten
"Kickstart" <[email protected]> wrote in message news:[email protected]...
>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 & on.
>
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
"Kickstart" wrote:
> 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 & on.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks