Another roundin' issue with $'s & cents

pshirley

New Member
Joined
Nov 22, 2005
Messages
1
Excel calculations: B3 = B1*B2 / B5= B3*.04 / B6= B3+B4+B5 /
The calculations show 2 decimals but use 3 for calculating gross.
590.625 doesn't round up to 590.63
WHY?
Enter the cells A1-6 and B1=6 as below in a spread sheet to see it...
A1Hours of WorkB143.75
A2RateB2$13.50
A3PayB3$590.63
A4otherB4$0.00
A5Vacation PayB5 $23.63
A6GROSSB6$614.25

:confused:
 

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
If you format the cell for two decimal places it will display as rounded to .63 However, to correctly round this up, you need to use round(), ceiling() or some other rounding function. see excel help
 

Forum statistics

Threads
1,078,249
Messages
5,339,081
Members
399,276
Latest member
Donjayok

Some videos you may like

This Week's Hot Topics

Top