per% formula of excel

friends aik aur new lecture ke sath aap ke samne hazir hoon aaj mera lecture yeh ke Excel mein Per% kaise niklate hain akasar hum marks ko percentage nikalte hain.

see below picture

aap ko bas yeh dekhana hai ke total marks kis column mein hain aur row kon si hai Obtained/ Total H column main hai aur row 3 hain to to hum formula es tarah se likhenge

 =sum(H3*100/500).
*  ye multiplication ka symbol hai es ke 100 likhna hai os k baad ye /divide ki symbol deni hai phir jitne total marks hai wo likhen 600 ho ya 800 ho, wo likhen.

aik aur bhi per% formula share kar raha hoon.

=sum(353*100/400)

es formula mein hum ne total column nahen likha hai ke kis mein hai direct hum ne marks likhi hai jo aap ne li hai os ke same formula hai aap ko opar bataya gaya hai.

Posted in: Excel lectures, HTML lectures