Automatic Generate School mark sheet advanced formulas in Excel

Friends, With the help of this video, the marksheet of the student in Excel can be very easy to extract many students together. You will find four to five formulas to learn, if you like the video, do not forget to share and subscribe.
After the Friendship video, you will get a video in which you can create the certificate by itself Corel Draw in a very aasan manner. If you like this video then the next video is definitely for you. You are just for the people and have made the certificate very easy. In the corel draw, with the help of which you will find a lot
Certificate Design Video- • How to Generate Unlimi...
Automatic Data Entry in Certificate video- • How to Generate Unlimi...
Sorry Friends ,RUclips Not allowed Formula in description.
Friends on this channel you are given absolutely original information about Microsoft Word Microsoft Excel Power Point Video Mixing Computer Hardware Laptop Hardware Online Information.
Friends, before uploading videos on this channel, it is kept in mind that this video should benefit you and you can learn a lot from one video.
Where does the friend go, no one has any work
My instagram Link : / ctechindia
My Instagram Personal Link : / chandan.ctech
Facebook Page Link: / ctechindia
My Other Hindi Channels:
Real Tutorial : ✅
/ @designapna
My Website: www.designapna.com/
#excel #ctech #dataentry

[@surendraclassic7845]

बहुत ही अच्छे तरिके से समझाहिये है भाई साहब पूरा दिल खुश कर दिए है

[@kajalchauhan364]

Sir thanku very much aapne bahut acche se explain kiya

[@bhoomiborsaliwala9866]

It's very helpful and explained very clearly... Ty sir :)

[@kajalbiddu7107]

App bhaut ache se samjate hai sir .I like.😄😄

[@24caratofficial]

Thank you so much sir
You were very helpful

[@geetalparmar8243]

Every nice video nicely explained indrajeet fm Nairobi Kenya thank you .

[@renumandavi4672]

Thank you so much ser

[@samfaryus]

Thank u sir . Pls share ur next video

[@geetikamalakar4797]

Thank u so much sir

[@surajeditingreactions6397]

Thanks its very helpful

[@legendary_vlogs_]

Bhot bdiya

[@anitasisodia6540]

Thank you🙏

[@Uianchakki8414]

Thank you Sir

[@rheapeter9709]

Thank you sir!!

[@brijmohanraghuwanshi4592]

Thank you bhai

[@SumanGupta-zi3dg]

Sukriya sir 🙂🙂

[@artofvillagerk9948]

Thank u sir.

[@sadashivkage3133]

Tq sir 👍👍

[@meenagupta3300]

good evening sir 🙏🙏

[@hellomrop1]

Waiting eagerly for next video

[@rajkumarchauhan003]

aap ne result farmula persent ke adhar par lagaya jo ki sahi nahi do subject me fail wala bhi aap ke farmule me pass ho jayega .pass subject ke adhar par farmula bataye plz.

[@vkvajpai6183]

Nice information

[@ankitadubey264]

Very nice video

[@sagarali8413]

thanks

[@nitinbajaj4948]

Nice thanks

[@ritiksharma4574]

Think you sir

[@decentboy892]

thanx sir

[@illuminatetv8577]

Thnx alot

[@zafarhm3050]

Very nice sir

[@aristocracy7220]

Thanks sir

[@manidipasarkar1984]

Thank u

[@khansahab-su1mx]

Complete school management ka video series banao bhai

[@AmarKumar-hg6wu]

Superb

[@user-uh3nl7mc3s]

Rank के फार्मूले भी बताएँ सर जी

[@zmuskammuskan7294]

Good work

[@ramshankaryadav9959]

Thanks

[@sagarali8413]

more easy way excel

[@MueedBhatti]

Bohet khoob

[@maheshpilli]

result formula is wrong bro....... The correct formula is....... =if(and(b2>35, c2>35, d2>35, e2>35, f2>35), "pass", "fail")

[@rakanmahmud5800]

I was looking for this, tnx

[@abdulraheemyounas6940]

I need your help bro
Kindly contact [e-mail]

[@dakutaviyadlaxmanbhai2365]

👍👍

[@kamrankolachikamrankolachi9872]

nice job

[@chamanirshad2508]

Very nice

[@reliablecomputers6785]

The tutorial is good but the result of an student do not depend on percentage rather on individual obtained marks

[@simritkaur3590]

very good #ak

[@chandrashekharborra4211]

Hi Sir,
I seen your video. It is very impressive. But, I got one doubt.
Doubt 1) Suppose if 3-4 students absent in 1 or more exams. then how will you show. Automatically the result will be FAIL.
Doubt 2) and one more thing if the student present in first 2 exams and then absent in rest of the exams, then how will you show.
Automatically the result will be FAIL.
Doubt 3) here how will you show the above condition (i.e. Doubt 2) in count of failure students.
Suppose , the total strength of the students is: 50,
in this strength 2 students doesn't attend the exam, now the total strength is 48 which they attend the exams right.
Suppose if the 3 - 4 students attend the first exam and in next 2 exams student was absent. that means 4 of 48 students students are failed in 2 subjects . then how will you show the count of passed, failed and absent.

[@abdulraheemyounas6940]

Hello air

[@naineshraval1245]

Nice

[@harivanshkumar1700]

Sir next video me result generate karna bataye...

[@archanagaikwad6409]

Nice video

[@C-TECH]

thanks

[@trahim1]

Can you also make a video in which to encircle a failed subject while printing a DMC? I am nor talking about data validation but how to encircle a failed subject if we want to print a DMC.

[@rishichapagai2396]

thanx for video. how to find total no of students?

[@MyWatchP1]

I am currently working on a similar software but I am facing a challenge. All students are reading the same core subjects but with different electives subjects. how do I import the class mark, exams mark and position from the master sheet onto the report? Can I get ur email address so I can share files with u for help?

[@ravimusicrs5208]

Nice video sur

[@nikhilranjan171]

Is there any formula to get 'TRUE' if the value in a particular cell is 'greater than or equal to' twice the value in an another cell? Plz rply. Thank You

[@anwaarulhaq786]

bro where is your next video of this topic ... complete this

[@mamtaraj9697]

Mamta Raj

[@TCMSumansaroj]

Marksheet ke all formula pr video

[@kharatdm]

Creat College level Semester Wise thory, internal Accademic Yearly marks sheet

[@crazyshakya0144]

👏👏👏👏👍👍👍👌👌✍️

[@singhpramod2065]

I want this second part sir please

[@ashutoshkumarashutoshkumar9304]

Pramod Singh

[@ramachandrannatarajan4234]

Understanding required

[@unknwn_usr3077]

please include absentees

[@myimaanofficial]

I need a formula to get the the marks of the students in another sheets where all the students and roll numbers are written and I want the formula to write absent if the formula don't find any mark.

[@DKVarma-es8ox]

Thank you Sir,
But I have a query that If a student have 70% marks but he is fail in any 2 subjects than he not pass... he is fail.So how I can show that he is fail or supplementary.

[@VIITEducation]

For this problem visit VIIT Guru

[@DKVarma-es8ox]

So we can not decided on the parentage base only that he is fail or pass. So please sir give me perfact solutions

[@sikanderbegwal2412]

hello ....agr koi.student kisi ek.exam mein 33 se niche hai to ...... agr usko.sum na krna ho to uska btao ...sum krte hue konsa formula.use hoga....... fail.wala.subject total mein consider ni hota

[@Dj_Sultanpur_Ahimane]

Corel draw ka video kyu nhi bna rhe hai

[@geetanjaligeetanjali1408]

Sir Aapne attendance sheet bhi banayi h

[@priyadarshininayak8675]

Secured mark sheet pe lete to aur achha hota

[@onlineguru7028]

Apka video a66a hai lekin isme apki ek galti hai... apne jo result vala column hai isme formula galat lagaya hai....kyoki apke formlua ke hisab se agar sab subjects me fail hoga tabhi fail ayega varna usko grade mil jayegha....matalab sabhi sujects k marks less than 33 hoge tabi percentage 33 hoge ....varna usko grade mil jayega...jab ki real me kisi nhi subjects me fail ho to fail hona chahiye....

[@MrHunzaikhan]

oiver all kitney studens fail howey or kitney absent rahey .....toatal k lia kia formula ho gha...thank you

[@arjushagolsem7546]

=if(............... Can take common in that grade formula......????? 🤔

[@naveedafriditv9028]

sir g ager passing marks different ho like kuch subject 40 passing marks ho aur kuch ka 30 ho to phir kaise formula lagayenge

[@kushalpathak641]

Supply mentry ka bata de bhai

[@lusikhosla3046]

Unit 1, unit 2 term1,unit3,unit4and term2 uska percentage and grade Nikal na he ta kese karenge plz reply karna

[@MasudRana-nf5ze]

Sir plz project file

[@jaydhankar6307]

Second video bhejo na

[@lakshyasingh4961]

need a edit at 3:24 seconds

[@ahmedsuleman7236]

Plz show with clear

[@gopal12344]

Sir vlookup ka use krke ek sath kae student ki marksheet kese bna sakte he ?

[@ishanultragaming1393]

Sir yeh batao aur bache students ka automatic kaise nikalte ho aap batao please help me

[@vikashdhiman5704]

If student is absent
What is the formula for result showing fail or absent

[@medn2tneetuganalysisandres727]

सर यदि Fee monthly calculate हो और irregular हो अर्थात मान लें कोेई छात्र 3महीने पर जमा करता है और कुछ dues रह जाता है तो इसका कैसे fee report generate करेंगे

[@padamthapa2137]

Where is your next vedio sir

[@ishanultragaming1393]

Sir yeh batao aur bache students ka automatic kaise nikalte ho aap batao sir mere laptop mein aisa nahi ho pa raha hai please help me

[@Rajeshyadav-kg1yw]

Mujhe Pura Excel sikhna hai please

[@rumpichanak1491]

Sir agar yaha 3 subject main fail hai to hi fail hoga nahi to pass sikhaye ga

[@pramodkumarsinha7614]

where is second video

[@makhansinha1079]

sir mujhe autometice report card fillup karna

[@riteshpanchal4516]

Sir esme muje jo fail hai uska grade Show nahi karna he to kese kare

[@mrmonu6494]

Sir aap sikh lo

[@rowdyboykanhasahoo2271]

Home kara

[@photoshoptrainer5095]

Cntct for certificate

[@anandipandit7658]

sarji abhi tak nahi bheje he (Agar 1 subject me 25 karu to fail aana chaiyeahe pass 30 mark me he)

[@AbhishekKumar-nx1jl]

Kariye thoda Dikhai nahi de raha hai theek sahi se zoom Karke dikhaiye

[@lusikhosla3046]

Report card k liye ta kese karenge

[@shivbahorvishwakarma9560]

PowerPoint kya hai eski jankari dijiye sir please

[@priyapandey9600]

Sir yehi formula repeat Karna hai

[@sonuraazverma5742]

Sir if ke formula me 33 kyu lagate hai sir me confusion hu msg ka jawab jarur dena plz..

[@reliablecomputers6785]

The minimum passing mark is assumed as 33

[@SangharshEKsafalta]

Supply kaise nikale sir ji

[@C-TECH]

is par video hai mere channle par

[@diwansalim8086]

Sir lekin isko print kese nikale ge