How to calculate GRADE in excel sheet important topic for CPT EXAM

[@hemantdewangan1617]

Thanks sir

[@pravalsingh5575]

great video sir

[@talisman6969]

AWSM..

[@Pankaj-lh7nb]

Great Job Swapnil Sirjee

[@sethayurveda3083]

I use this formula. =if(g6>=80,"A",if(g6>=70,"B",if(g6>=60,"C","Work hard"))) please reply

[@talisman6969]

sir please arrange the videos coherently of MS excel in the playlist of MS excel...

[@SWAPNILSIR]

Ok i will make a new playlist for Excel

[@lord_governor]

Helpful sir.

[@soniachintakindi1391]

Excellent Bro......

[@kundandubey7161]

Very informative video
Keep uploading
Thanks

[@CrazyCloudz.]

it is mandatory to put values in decreasing order in the formula?... as you did 80 70 60

[@SWAPNILSIR]

yes it is mandatory.

[@rohittripathi6569]

Nice topic sir

[@advisornaresh5373]

Sir plz backspace aaega ya nhi typing me ye pkka btao

[@SWAPNILSIR]

agar koi word type kar rahe ho to spacebaar dabaane ke pahle backspace use kar skte ho,
but
ek baar spacebaar dabaa diye to backspace kaam nahi karega

[@ruchikumari2643]

sir grade to if function se bhi nikala jata jo easy hota formula se so please sir if function se btaiye.

[@sr729]

Sir plz provide pdf link for cpt rules n guidelines and some questions for practice. .

[@SWAPNILSIR]

join telegram channel
t.me/currentaffairsandgk

[@sr729]

SWAPNIL CURRENT AFFAIRS sir can you provide it in description box

[@kk-tv6kf]

Sir, there is a mistake. You have included Age also in total marks.

[@RaviKumar-cc2ym]

Sir ek baari grade find out karne ki video phir se bana doo plzz

[@arupray6194]

Please make video on embedding object and dynamic linking

[@sethayurveda3083]

Sir maine same sheet bnayi hai and same formula lgaya hai then every cell of grade show work hard

[@SWAPNILSIR]

ohh,
jo column hoga wo "percentage" ka hoga use "general" kar do aur % ka sign bhi nikal do fir try karo.

[@sethayurveda3083]

SWAPNIL CURRENT AFFAIRS no sir no changes koi effect nhi pdha

[@The_Magician7777]

Command m value ke baad % ka sign lagao or column ko percentage m hi rehne do

[@gauravbhakuni3323]

Put % sign (Shift+5)after percent value for ex 80% instead of just 80

[@RaviKumar-cc2ym]

Sir aap isme age ko v add kr ke uska percentage nikal diye hoo

[@ruchikumari2643]

nice sir.. really great sir. aisa lagta tuition lene ki jarurat ni parega

[@tripleh5369]

Kvs ldc job central government job hai ya fir kvs ek autonomous body hai ?

[@Dkm089]

grade me farmule me space dena h kya work nhi Kr RHA plz reply

[@SWAPNILSIR]

NO SPACE
desending order me hona chahiye
jaisa formula hai waise hi work karega
field ka format ek bari dekh lijiye general hai ya nahi

[@rohitdiwan5347]

Sir typing me exam me choice hogi kya hindi, or English plz reply

[@SWAPNILSIR]

YES,
100% Choice hogi Hindi OR English

[@nipurnsaxena6554]

Sir Maine grade ka formula apply kia but grade ke column me Work Hard aa raha hai

[@SWAPNILSIR]

assending order me lagao
jaisa video me lagaya hai same to same
aur column ko general rakho

[@rohitgupta2150]

Ye formula work nhi kar raha hai mere computer par

[@SWAPNILSIR]

it will work..
please follow all steps

[@rohitgupta2150]

Sir ye percentage ke column se % ka sign kaise batayenge value se..

[@SWAPNILSIR]

percnetage wala video dekh lijiye usme hai ye.

[@rohitgupta2150]

SWAPNIL CURRENT AFFAIRS okk

[@sagarmishra6911]

Sir ms word or ms power point ki vedio bhi bnaye plz

[@SWAPNILSIR]

MS WORD
ruclips.net/video/zqKbycZ7P0g/видео.html
POWER POINT
ruclips.net/video/2661kC83I0I/видео.html
JALD AUR VIDEOS AAYEGI

[@rachnasingh1315]

Sir mera nhi aa rha grade .. hard work show ho jata ha last me bass.. bar bar shi formula put kr rhi hu but nhi aa rhaa.

[@SWAPNILSIR]

telegram group me excel format me wo spreadheet share kiya tha wo download karke usme try kare
desending order me hona chahiye sabse pahle 80 fir 70 fir 60 iss type se

[@Dkm089]

work nhi Kr RHA he setting bhi general he ms excel 2007 h

[@RaviKumar-cc2ym]

Sir mere se nahi find out ho pa raha hai grade baar baar sare me work hard repeat ho ja raha hai

[@SWAPNILSIR]

aisa to nahi hona chahiye.
jaisa formula lagaya same waise hi rakho aur maximum se minimum aur column ka format bhi check kare.

[@anamikajaiswal5093]

nhi ho Raha sir PURA work hard ho ja Raha fir se Bata dijiy sir

[@SWAPNILSIR]

ok
result late hone ke wajah se video's nahi aa rahi hai
jald videos aayegi

[@The_Magician7777]

Command m value ke baad % ka sign lagao or column ko percentage m hi rehne do

[@shilpigupta614]

sir ban nahi raha..

[@kiransahu3971]

Sir grade ka formula false bta ra h

[@SWAPNILSIR]

EK DO BAAR AUR SE TRY KARE

[@Dkm089]

ye work Kr RHA he but

[@Dkm089]

false likh Kr a RHA h

[@shilpigupta614]

DINESH MADHUKAR mera bhi

[@advisornaresh5373]

Or typing k liye A4 sheet milegi ya computer me krni hogi??

[@SWAPNILSIR]

computer par hogi

[@sandeepruhil7087]

Thank you sir