فرمول محاسبه مالیات حقوق و بیمه و تعیین حقوق خالص از ناخالص

=IF(E3<=100000000,0,IF(AND(E3>100000000,E3<=140000000),(E3-100000000)*10%,IF(AND(E3>140000000,E3<=230000000),4000000+(E3-140000000)*15%,IF(AND(E3>2..................................................................................................................................................................................

فرمول بیمه

IF(B3<=3715.....................................................