To Create A Result Sheet Microsoft Excel XP

To Create A Result Sheet (QvÎ/QvÎx‡`i cix¶vi djvdj †ei Kiv) t

NB t †Kvb wk¶v cÖwZôv‡b KvR Ki‡Z n‡j QvÎ/QvÎx‡`i cix¶vi djvdj †ei Ki‡Z nq| hw` cÖwZôv‡b A‡bK QvÎ/QvÎx

_v‡K Z‡e Kw¤úDUvi Qvov mevi djvdj †ei Kiv A‡bK KóKi Ges A‡bK mg‡qi KvR| ZvB GB KvRwU Lye mn‡R

Kw¤úDUvi w`‡q K‡i †bIqv hvq| Avmyb Avgiv wb‡æewb©Z Q‡Ki mvnv‡h¨ wKfv‡e Lye Kg mg‡q m~Î cÖ‡qv‡Mi gva¨‡g A‡bK

QvÎ/QvÎxi cix¶vi djvdj †ei Kiv hvq Zv wkwL|

D³ QKwU h_vixwZ ˆZix Kivi ci QvÎ/QvÎx‡`i cÖvß b¤^i wVKgZ emv‡Z n‡e| QvÎ/QvÎx‡`i cÖvß b¤^i ¯^t ¯^t N‡i emv‡bvi

ci wbæwjwLZ m~θ‡jv cÖ‡qvM Ki‡jB Avgiv cix¶vi mwVK djvdj †c‡q hve| g‡b ivL‡eb wbw`©ó Cell Gi g‡a¨ m~θ‡jv

cÖ‡qvM Kivi ci Inter Press Ki‡Z n‡e|

 G2 Cell G Mouse Pointer ‡i‡L t

=SUM(E2,F2) A_ev =E2+F2

 J2 Cell G Mouse Pointer ‡i‡L t

=SUM(H2,I2) A_ev =H2+I2

 Q2 Cell G Mouse Pointer ‡i‡L t

=SUM(G2+J2+K2+L2+M2+N2+O2+P2) (SUM e¨envi wb®cÖ‡qvRb)

 R2 Cell G Mouse Pointer ‡i‡L t

=IF(Q2>=890,“STAND”,IF(Q2>=750,“STAR”,IF(Q2>=600,“FIRST”,IF(Q2>=450,“SECOND”,IF(Q2>=330,“THIRD”,“FAIL”)))))

 S2 Cell G Mouse Pointer ‡i‡L t

=IF(OR(G2<66,J2<66,K2<33,L2<33,M2<33,N2<33,O2<33,P2<33),“FAIL”,“PASS”)

 T2 Cell G Mouse Pointer ‡i‡L t

=Q2/10

To Copy The Formula (dg©~jv Kwc Kiv) t Salary Sheet ‰Zix Kivi mgq wbðqB dg©~jv Kwc Kiv wk‡L‡Qb| dg©~jv

Kwc Kivi wbqg GKB| Result Sheet Gi dg©~jv Kwc Kiv wk¶‡Ki wbKU †_‡K †R‡b wbb|