To Create A Wage Sheet Microsoft Excel XP

To Create A Wage Sheet (gRyix mxU ‰Zix Kiv) t

cÖkoe t GKwU cÖvB‡fU †Kv¤úvbx‡Z GB k‡Z© wKQy †jvK wb‡qvM Kiv n‡jv †h, Zv‡`i mevB‡K wbqwgZ 8 N›Uv K‡i KvR Ki‡Z

n‡e| GB 8 N›Uv Kv‡Ri cÖwZ N›Uvi Rb¨ Zv‡`i‡K 20 UvKv K‡i †eZb cÖ`vb Kiv n‡e| Avi GB 8 N›Uvi AwZwi³ †h hZ

N›Uv KvR Ki‡e †mB mg‡qi Rb¨ cÖwZ N›Uvq Zv‡`i‡K 28 UvKv K‡i cÖ`vb Kiv n‡e| GB kZ©vbymv‡i Overtime & Total

Payment Gi wnmve evwni Ki‡Z n‡e| GB mgm¨v mgvav‡bi Rb¨ wb‡goe ewb©Z QK Ges m~θ‡jv Abymib Ki“b|

E2 Cell G Mouse Pointer ‡i‡L: =IF(D2>=8,D2-8,0)

F2 Cell G Mouse Pointer ‡i‡L: =IF(E2>0,8*20+E2*25,D2*20)

D³ m~ÎwU cÖ‡qvM Kiv n‡q †M‡j Enter Press Ki“b| AvkvKwi djvdj ‡c‡q †M‡Qb| Gevi Formula Copy Ki“b|

wbðqB mevi djvdj †c‡q‡Qb| Gfv‡eB A‡bK kªwg‡Ki gRyix mxU ˆZix Kiv hvq|