How to Create Mark Sheet in MS Excel step by step || Fully Automatic Marksheet In Excel |

How to Create Mark Sheet in MS Excel step by step || Fully Automatic Marksheet In Excel |

EXCEL ADVANCE MARKSEET IN EXCEl IN HINDI Automatic Generate School mark sheet advanced formulas in Excel How to Create Mark Sheet in MS Excel step by step || Fully Automatic Marksheet In Excel |

This video tutorial includes percentage, total sum where fail in one subject means fail in class.

to make this we will use and if and sum function in Excel.

To create advance mark sheet if for sum function =sum(a1: d2)

if marks are more than 35 students is pass otherwise fail means studens need to pass in all subject

=if(and(c3>35,d3>35,e3>35,e3>35),”pass”,”fail”)

11 views

Leave a Reply

Your email address will not be published.

Newsletter Signup

Subscribe to our weekly newsletter below and never miss the latest product or an exclusive offer.