The following sources of a nidrista terms of are. If any of the terms of the Payroll find you.
C2 Cel C2 Cell G Mouse Pointer, leaving
= IF (B2> = 8000, B2 * 45%, IF (B2> = 6000, B2 * 35%, IF (B2> = 4000, B2 * 22%, B2 * 15%)))
D2 Cell of the Mouse Pointer in,
= IF (B2> = 8000, B2 * 40%, IF (B2> = 4500, B2 * 28%, B2 * 18%))
E2 Cell of the Mouse Pointer in,
= IF (B2> = 8000, B2 * 34%, B2 * 22%)
F2 Cell of the Mouse Pointer in,
= SUM (B2.E2) or = B2 + C2 + D2 + E2
G2 Cell of the Mouse Pointer in,
= B2 * 12%
H2 Cell of the Mouse Pointer in,
= IF (B2 <5000,0, IF (B2 <8000, (B2-5000) * 1%, (B2-5000) * 2% +90))
I2 Cell of the Mouse Pointer in,
= IF (B2> = 7000, B2 * 22%, B2 * 8%)
J2 Cell of the Mouse Pointer in,
= SUM (G2.I2) or = G2 + H2 + I2
K2 Cell of the Mouse Pointer in,
= + F2-J2
========
নিম্ন লিখিত সূত্রগুলো একটি নিদ্রিষ্ট শর্তের উপর ভিত্তি করে দেওয়া আছে। পারলে যে কোন শর্তের উপর ভিত্তি করে বেতনের হিসাব বের করতে পারবেন।
C2 Cel C2 Cell G Mouse Pointer রেখে,
=IF(B2>=8000,B2*45%,IF(B2>=6000,B2*35%,IF(B2>=4000,B2*22%,B2*15%)))
D2 Cell এ Mouse Pointer রেখে,
=IF(B2>=8000,B2*40%,IF(B2>=4500,B2*28%,B2*18%))
E2 Cell এ Mouse Pointer রেখে,
=IF(B2>=8000,B2*34%,B2*22%)
F2 Cell এ Mouse Pointer রেখে,
=SUM(B2.E2) অথবা =B2+C2+D2+E2
G2 Cell এ Mouse Pointer রেখে,
=B2*12%
H2 Cell এ Mouse Pointer রেখে,
=IF(B2<5000,0,IF(B2<8000,(B2-5000)*1%,(B2-5000)*2%+90))
I2 Cell এ Mouse Pointer রেখে,
=IF(B2>=7000,B2*22%,B2*8%)
J2 Cell এ Mouse Pointer রেখে,
=SUM(G2.I2) অথবা =G2+H2+I2
K2 Cell এ Mouse Pointer রেখে,
=+F2-J2