Để có thể tính thuế thu nhập cá nhân trong Excel ta lập một hàm sau trong modul của Excel
Function Pit(Income As Double) As Double
Select Case Income
Case Is <= 0
Thue = 0
Case Is <= 5000000
Thue = Round(Income * 0.05, 0)
Case Is <= 10000000
Thue = Round(Income * 0.1, 0) - 250000
Case Is <= 18000000
Thue = Round(Income * 0.15, 0) - 750000
Case Is <= 32000000
Thue = Round(Income * 0.2, 0) - 1650000
Case Is <= 52000000
Thue = Round(Income * 0.25, 0) - 3250000
Case Is <= 80000000
Thue = Round(Income * 0.3, 0) - 5850000
Case Is > 80000000
Thue = Round(Income * 0.35, 0) - 9850000
End Select
Pit = Thue
End Function
Sau đó dùng hàm như sau
Tại ô B5 chứa giă trị cân tính thuế TNCN, tại ô C5 là giá trị thuế TNCN phải trích nộp, ta ghi công thưc tại ô C5 như sau : = Pit(B5)
(Theo Xuân Thanh, diendanthue.com)
Many CNC tools have no inherent sense of the absolute place of the table or tools when turned on. They should be manually Toilet Flappers "homed" or "zeroed" to have any reference to work from, and these limits are only for figuring out the placement of the part to work with it and are no onerous motion limit on the mechanism. It is usually attainable to drive the machine outdoors the bodily bounds of its drive mechanism, resulting in a collision with itself or harm to the drive mechanism. Many machines implement management parameters limiting axis motion past a certain limit in addition to bodily limit switches. Because CNC machines can create elements from a number of} kinds of materials, they'll make everything from the brakes to the engine elements and even tools. Just as passenger cars are evolving to turn into more environment friendly, cargo vehicles in the transportation industry face similar adjustments.
Trả lờiXóa