Nested IF Condition in Excel in Tamil
ฝัง
- เผยแพร่เมื่อ 19 พ.ค. 2020
- Learn how to use Nested IF condition in Excel with Examples.
Check out other IF Condition Tutorials
IF And Formula in Excel in Tamil
• IF And Formula in Exce...
IF Condition in Excel in Tamil
• IF Condition in Excel ...
Drop your doubts and suggestions in the comments. Don't forget to Like and Share the Video.
*****************
MS Word Tutorial in Tamil
• Watermark in MS Word i...
PowerPoint Tutorial in Tamil
• PowerPoint Animation T...
******************
#exceltutorialintamil #endlessknowledge
Neenga super aah teach panringa ippa Naa ellam doubts ku unga videos tha paakuren thank you anna😊
Romba romba thanks bro . Best explanation best teaching,super bro supera puriyura maari explain pannirukinga ungala maathiri yaarum sollala bro thanks a lot bro!!!! 🎉❤
My kind request is please make single play list for if formula videos. Pls do the. Need full. So. That we can understand that all the criteria of usage of if formula function
Super, மிக நன்றாக இருந்தது
Excellent teaching! Thank You!!
Also remember when dealing with grades you have to Use nested if in Top down manner, not bottom up manner means you have to start first from 90(then),80,70 not 70(then),80,90. Otherwise you will satisfy the logic in the first condition
Yow..ne Vera level ya...hatesoff broo...best teaching 💜
Much appreciated brother 💯❤️💪👏👏👏
80% score panni 1 subject la fail aa iruntha enna panrathu bro 😢
Epdi no grade podrathu
Fail ana no grade podanun bro
But 80% nrathu nala" A " Grade varuthu bro
Thank you so much sir this formula helps me a lot........
Hi sir, can you set the same condition for time?.
Thank you very much for your reply sir.
அருமை, சுலபமா இருக்கு சார், THANK YOU BROTHER
Very very useful..Keep up the good work
Hi,
I need to verify two diff data from two diff cells and get the value in single cell how to get that in nested if for text values
Thank you soo much for your video. have a doubt can we use if condition with names? if i try this method with name it shows some error Called Name
Very easy to understand only because of your nice presentation in coherence. I want to select the text in a cell where the table is full of text. instead of numbers where five columns are in a table. How to do
Nice Very good teaching
Nice very useful 🙏
நன்றி
Can you use this for a range of number..for example 90 to 100 A+ etc..
Good video.
Thank you
Above video is very useful.
how to do nested if for range of values?
Nice explanation sir
Good job
Your videos are really helpful for me. In this video you should have consider the Result also.
Without writing a subject student can gain above 70 Average.
Assume Avg. Is 70 in four subjects . One is Absent. Can you give him the B grade to a failed student?
Sir
nested if function 45 logics work pannuma and also can I use it in row vise
Please guide me sir
sir, if we take average for grade calculation, all subjects got centum, except in one subject, assume less than 60...then again the average will be in 90s....so how to go about it sir. pls clarify
Sir, Thank you...
Good teaching bro
You are great
Sooper Master Thanks
Sir one of the students is fail or absent in only one subject sir, but got average above 60% sir. For him also it is displaying grade sir. No grade only should display know sir. How to rectify it sir????
Sir one doubt... Intha video la irukka data la example ku
One student fail in one subject, but he scored 70% ippo grade epdi calculate panrathu....
Dear Sir Thanks for your videos. I had got stuck in using the formula for calculation of PF. please help me. M value = 1800/-
I need to use roundup, with conditions as well. condition 1. if the value of A+B+C*12% is greater than 1800/- limit to 1800/- 2 if the value of A+B+C*12% equal to or less than 1800/- then calculate actual.
Sir I have one doubt.
One cell i can't fill 12 digit number.
If i am fill auto changes.
So can you explained please.
I have a one doubt how figure it between numbers for example 90 - 120 and 120 above.
Completed this exercise bro, Thank you.
your most welcome brother... Keep learning more about excel important functions th-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html
Sir I don't have IFS and Nested formula, so pls tell me alternative formula like IFS and Nested condition
Veraaa level
Sir, how to do vlookup with multiple criteria using if function like multiple col.index number in vlookup.
SUPER EXPLANATION
Well and clear explanation.
Thank you bro 👏👏👌👌
Welcome 👍
Bro inthukku average okk bro 5 subject each 100 mark so this formla ... but incause 6 subject each 200 mark in old 12th type result ... so this type we which formla use pannanum sir .. pls clarify this
Bro na capital letters illama full la type pannitan ippo oru oru word Kum capital eppadi change pannuradhu konjam solluga bro...."proper" use pannure mathire venam
fine sir
Simply and good presentation sir and your voice, teaching methods very well sir...
Thanks and welcome
Simply super bro. Amazing explanation with your voice is also supeb. How to make a TH-cam videos like this type of educational purposes. What are the softwares and tools are needed. Kindly make a new videos for how to make a youtube videos. It will be useful to all. I am impressed with the way of teaching. Don't stop...
Thank you so much 🙂
Bro, if the lookup value is empty find the below cells. Kindly share the formula. Need your help bro
Bro help me
I need solution
Constant lenght 5800mm
Cut peice 1530 in 8 peice in one lenght 3 peice
Remaining as wastage for one lenght
In excel how can I get this
Sir if function thodarpana all questions and answers ah konjam vilanga padutha mudiyuma sir
sir , very good, im learning sir intersting
Keep watching...
We can also use IF method to find the result easily....
Hi sir,
If you were fixed 60-70% as "No grade" then how will be 53.6% showing No grade?
Bro suppose student fail in one sub but his average is above 70 what his grade?
Good information and good explanation. May God help you
Thanks and God bless you too...
HI SIR
There are five subjects if he got 100marks in 4 subjects and he got 34 fail mark in a subject ,his average is 86.8%,but result (fail) what is the grade
super .. very useful
Glad you liked it... Keep Learning more about Excel th-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
Thank you sir
Welcome
Average vetchi grade kandupidikkum podhu fail anavangallukum grade varuthu bro result and average vetchi epdi grade calculate panradhu bro
Super sir thanks lot
Your welcome 👍
Great video . How to extract the first digit number in 4 digit number eg. 5600 to 5
Sir semmaiya puriyudhu.But I just would like to ask about any other example entha mattiri nested formula use panna mudiyum?
will post soon but also take a look at this latest function th-cam.com/video/tlbxW8pbxKU/w-d-xo.html
Greeting Sir, Very nice explanation
Thank you, you might also like
MS Word Tutorial in Tamil
th-cam.com/video/pC8IYOU3v5Q/w-d-xo.html
PowerPoint Tutorial in Tamil
th-cam.com/video/O84Ut-ekKI0/w-d-xo.html
your videos are very useful for me,sir..thank u very much..Is there any easy way to make a overall timetable ( master timetable) using all class timetable?
Will upload soon
@@EndlessKnowledge Thank u sir
அருமை sir
thanks...
Everything is good sir and we need power query.
It's getting ready
Nice gud example....
Thank You.
Bro i hava a dout ... ippa one subject mattum fail aituu rest of all subject with good marks yaduthrudha indha formla use panna andha fail anna person ku grade apply agudhu but fail anavugaluku yapidi grade podradhu
RA ennu podalam
Hi I have 1 doubt ,how to get hourly sale reports
Time / sales value
10:00 / 999
10:10 / 1499
10:20 / 4999
10:40 / 3499
11:00 / 3499
11:35 / 4499
11:50 / 7999
12:00 / 599
I want hourly sale data
10:00 - 11:00 / sale value
11:00 - 12:00 / sale value
What is the formula pls tell me
👍👍👍
Super 👌😊
Thanks
Super anna tku 🙏🙏🙏
Your welcome...
Even if the result is fail but average is more than 80 how to make changes in nested if formula
Nice,max how many if can use?
7
Sir oru chinna doubt suppose oru student ore oru exam mattum fail matha ella examlaum above 90 so average 70% ketta varum pothu avangalukkum grade vandhudume sir so adai avoid panna enna formula use pantrathu sir
You don't have to avoid that because that's the concept of Grade...
I tried >=60 is D grade,
Bro python pathi video poduga bro .
❤❤
🔥💯👍
Bro if your good explainer put how to edit TH-cam video in your channel.
❤💕 Love you
Thank you so much for your love and support... Keep learning more about excel important functions th-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html
Bro epo 55 num mattum venum 55.00 varthu only 55 mattum venumna yanna pandrathu
😍👌🏽👌🏽
nested if ல் maximum எத்தனை if condition open பண்ணலாம்.
Result formula apply senja and varala
Video clear ah podunga sir
Yevalavu true or false check pannalam bro
Intha formula copy panni Vera file ku kondu poga mudila bro
எளிமையான விளக்கம் சார் நன்றி.!
Your Welcome...
Bro. Between numbers formula podunga pls.
sure...
fail la iruntha grade varum.
என்ன பண்ண போறோம் அப்படினா
என்ன பண்ண போறோம் அப்படினா
How to give Range in if condition.
Ex. Average 80 to 90 A+
70 to 80 A
Please explain Sir
greater than 80, greater than 70
Rank ?
here it is th-cam.com/video/Q2lon3EVUHo/w-d-xo.html
Sir formula bar close panna oru idea enakku solli irundhinga adhaium solli irundha viewerskku use fulla irundhu irukkum...
Sure... Next video...
@@EndlessKnowledge thank you sir
Video not clear😔
Unga mail ID need bro
very happy, in my lanuge tamil, slow study, easy understanding, im also practising , sir this is great , plase share your contact phone or email please , im in chennai alwarpet sir
Glad to hear that from you... you can contact me at geomouse1715@gmail.com
Excellent teaching! Thank You!!
your most welcome... Keep learning more about excel important functions th-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html