mao ni akong prob sa excel,
ex. 14.96875 X 250 = 3,742.1875. when round off to 2 digit, it gives 3,742.19.
akong gusto mu 3,742.15 or 3,742.20 unta.. anyone can help here?
Results 1 to 6 of 6
Thread: Using Ms Excel as payroll
-
09-02-2006, 06:48 PM #1Banned User
- Join Date
- Sep 2003
- Posts
- 3,912
Using Ms Excel as payroll
-
09-02-2006, 08:02 PM #2Junior Member
- Join Date
- Jul 2003
- Posts
- 105
Re: Using Ms Excel as payroll
see the roundup, rounddown and round off function
-
09-03-2006, 08:35 PM #3Elite Member
- Join Date
- Apr 2005
- Posts
- 1,219
Re: Using Ms Excel as payroll
mura dili ni madala ug usa ka function, walay shortcut. gamit paka ani ug more than 1 cell para sa temporary computation. gamit paka ani ug mod function, division, and multiplication to process the decimal places.
-
09-05-2006, 04:25 PM #4Banned User
- Join Date
- Sep 2003
- Posts
- 3,912
Re: Using Ms Excel as payroll
hatag daw ug sample ani bro luk..
Originally Posted by abloyboat
-
09-05-2006, 06:55 PM #5Elite Member
- Join Date
- Apr 2005
- Posts
- 1,219
Re: Using Ms Excel as payroll
download the link below. zip file na siya sa excel file. dili tingali na mo answer diritso sa imong gipangita but i'm sure, more or less, mao na ang computation. palihug nalang pod ko ug check basin naay bugs. then post pod kung unsay dagan na sa imong excel.
http://www.geocities.com/chess_partn...ce_payroll.zip
-
09-05-2006, 08:04 PM #6Banned User
- Join Date
- Sep 2003
- Posts
- 3,912
Re: Using Ms Excel as payroll
ok, thanks bro..
Reply With Quote Advertisement
Similar Threads |
|
Posting Permissions
|