super mega mind computer

super mega mind computer
REGISTRATION NO.204/AG/-58125/55/U.P

how make marksheet and comany salary grade in ms excel #smmccgonda

SMMCC February 24, 2021

#smmccgonda



MS EXCEL MARKSEET AND SALARY GRADE 


"Keyword" "student database excel sheet download" "excel marksheet percentage formula" "marksheet format in word download" "mark sheet grade formula in excel" "create marksheet" "school result software in excel free download" "student marksheet in excel template" "excel marksheet grade formula" "steps to create marksheet in ms word" "excel marksheet formula pass fail" "how to make 1000 marksheet in excel" "average formula in excel marksheet" "make a marksheet in ms excel applying formula"


 

Total =sum(b2:f2) 

select area where till you want to sum

Percentage =G2/5  

Result =IF(B2<33,"fail",IF(C2<33,"fail",IF(D2<33,"fail",IF(E2<33,"FAIL",IF(F2<33,"fail","pass")))))

Division= =IF(H2>=60,"F",IF(H2>=45,"S",IF(H2>=33,"T","fail")))

 


"Keyword" "salary sheet format in word" "salary slip format in excel with formula" "payroll format pdf" "salary register book pdf" "salary breakup calculator excel 2019-20" "automatic salary slip generator using excel" "salary sheet in excel caclubindia" "acquaintance roll format in excel" "salary register format as per factory act" "minimum wages calculation in excel format" "excel salary sheet bangla tutorial pdf" "basic salary" "payroll summary report in excel" "ethiopian payroll system pdf" "excel complex formulas" "monthly salary calculation formula" "basic salary percentage" "wage calculation" "in hand salary calculator india excel" "fbp allowance"


TA==B2*4/100

DA=B2*10/100

HRA=B2*6/100

NET SALARY ==SUM(B2:E2)

COMPANY GRADE=IF(B2<=10000,"C",IF(B2<=15000,"B",IF(B2<=23000,"A",)))








Reactions

Post a Comment

0 Comments

thank you