How to Assign Letter Grades in Excel using #vlookup #youtubeshorts (forget IF function)

preview_player
Показать описание
Calculating and assigning letter grades to students based on their achieved score is a common task. I'll show you how a super simple solution in Microsoft Excel to automate this task. Forget the Excel IF function for this. Instead use Excel VLOOKUP function.

Excel Tips & Tricks using - #vlookupfunction #youtubeshorts

Tags.
excel tips
excel tricks
excel in hindi
a to Z Excel
excel tips and tricks
excel shortcut
excel online course
excel in hindi
cool excel tricks
Microsoft excel tips,
MS excel tips and tricks
Hindi technology
computer Hindi
excel tips and tricks you must know
#exceltipstricks
#excelhinditips
#exceltipshindi
excel short video,excel shorts,excel reels,excel advanced tutorial,excel shortcuts and tricks,excel shortcuts,excel shortcut key,excel,excel tricks,excel short tricks,excel tips and tricks in hindi,excel tips and tricks advanced,excel formula tricks,advanced excel tricks,advanced excel formulas and functions,advanced sum function in excel,advance vlookup,advanced excel functions,advanced excel formulas list,#youtubeshorts,#shorts,SK Learning Junction,advanced countifs function in excel
Рекомендации по теме
Комментарии
Автор

Thank you so much I have watched many videos but no formula worked for me then I tried your formula and it worked at once.

maham
Автор

Very Use I like Your all video Dear keep it up continue

munnabhaishiyal
Автор

Is it possible to apply vlookup without inserting any column?

saukatali
Автор

What if someone absent for any subject. Then how to put absent for them without giving F grade.

indunilkarunarathne
Автор

It's awesome idea, i was trying if elase and formula from last 1 hr but I didn't get out put but this idea has given me some output

amarsonagara
Автор

Bhai ek question tha ki
IF se bhi solve ho skta tha na ?

uchihastech
Автор

If the score have - score. How sir isnthe command?

ija
Автор

Sir ye apne, 2 kyun lagaye hai ye bta sakte hai aap mujhe

MohitKumar-iwio
Автор

Sir, your trick is slightly wrong,
=vlookup(lookup value, table array freeze, 2, 1) & ctrl+E is not working

abhishekverma
Автор

Sir, ji Ctrl E karney par apney aap score nahi aa raha hain, pls suggest

ynagesh
Автор

Why is that 2 used in the formula at the end ?

tanyarafeeque
visit shbcf.ru