Excell 2003 formula ?

Oldschool
Profile picture for user Oldschool
Posts
1075
Joined
8/29/2006
Location
IL US
Oldschool
Edited Date/Time 1/24/2012 4:25am

Hi guys
I have = c3+c6+c9 etc. ($0.*.* , $0.*.* , $0.*.*)
But I get $0.181 instead of $1.81

Thank you
Tony
|
Frogman
Profile picture for user Frogman
Posts
906
Joined
10/14/2006
Location
Washington, DC US
Frogman 4/3/2008 11:23am
4/3/2008 11:23am Edited Date/Time 4/3/2008 11:24am
April fools is over right? Those 3 added = 1.018

.40+.48+.93=1.81
Oldschool
Profile picture for user Oldschool
Posts
1075
Joined
8/29/2006
Location
IL US
Oldschool 4/3/2008 12:26pm
4/3/2008 12:26pm
Those numbers I whipped up in a hurry to get the point across
(The formula is like 25 cells added together)
But Why an I getting $0.181 cents instead of a dollar and 81 cents $1.81 ?

Thanks
Tony

Frogman
Profile picture for user Frogman
Posts
906
Joined
10/14/2006
Location
Washington, DC US
Frogman 4/3/2008 12:34pm
4/3/2008 12:34pm
sounds like you keyed it wrong.

40 cents = $.40 not $.04.

Post a reply to: Excell 2003 formula ?