Student Grade|IF|AND|OR in Microsoft Excel 2016 in Tamil

  Рет қаралды 134,511

Tutor Joe's Stanley

Tutor Joe's Stanley

Күн бұрын

sum formula in Excel.
count formula in Excel.
countif formula in Excel.
max formula in Excel.
min formula in Excel.
if formula in Excel
Logical Operator in Excel
Relational Operator in Excel
Learn Computer Technology By Tamil
For Free source code and Free Project Please visit :
www.tutorjoes.com/
/ tutorjoes
/ tutorjoes
Background Music : Royalty Free Music from Bensound
HASH TAGS
#tutorjoes #gstbill #exceltamil #DailyExcel #TJBILL #TJEXCEL

Пікірлер: 94
@Tamilneasan
@Tamilneasan 5 жыл бұрын
இதை விட தெள்ளத்தெளிவாக யாராலும் சொல்லித்தர இயலாது உங்களது பாடம் ஒவ்வொன்றும் மிக எளிமையாக புரியும் படி எனக்கு பயனுள்ளதாக உள்ளது மிக்க நன்றி உறவே
@janusdiary
@janusdiary 2 ай бұрын
Bro unga videos na ipo tha pakka aralbichuruka bro unganalatha na excel kathukitu iruken thanks for teaching bro ❤☺️
@senthamizh604
@senthamizh604 2 жыл бұрын
Clear explanation.... I'm a beginner .... it's very useful to me......thanks sir
@artistjanane4257
@artistjanane4257 3 жыл бұрын
Very useful sir. You had done a great job. Thanks a million. Appreciate your efforts 🙂.
@dsp3335
@dsp3335 6 жыл бұрын
Very clear voice output,easyly understand sir...I started watching your videos on daily basis..thank you...
@tutorjoes
@tutorjoes 6 жыл бұрын
Thank you
@jothimaninataraj9463
@jothimaninataraj9463 6 жыл бұрын
Very Very nice topic Your support need to me anytime I have been regularly following your tutorials thank you Sir...
@kamarajmanimozhikamarajman9258
@kamarajmanimozhikamarajman9258 5 жыл бұрын
Anna super anna patikathavanga kuta purinchikiramathiri solringa anna thanksna
@natarajanramakrishnan2341
@natarajanramakrishnan2341 11 ай бұрын
Excellent coaching 🙏🙏🙏
@sathyaspace
@sathyaspace Жыл бұрын
by the way your videos are really awesome..keep up the great work
@padmavathysundar8565
@padmavathysundar8565 4 жыл бұрын
Thank you so much sir for your great work..but felt little bit confused while framing a nested if condition.. give me some examples to do practice on the same..thanks in advance.
@baskibabu826
@baskibabu826 5 жыл бұрын
Sir neenga class edukrathu rmba nalla iruku sir Clear-cut a explain pandringa Apdiye c programming language class m podunga sir please
@gurnathan07
@gurnathan07 4 жыл бұрын
Super explanation sir... Awesome teaching
@marvelmalaysia373
@marvelmalaysia373 4 жыл бұрын
Very helpful ...thanks for your service.
@fahadhrafeeudeen9483
@fahadhrafeeudeen9483 3 жыл бұрын
Sir it's been so great that I am learning Excell through your videos. Can you please explain how can we grade if there is an absent student in a particular subject. What condition we can put.
@pradeeworld4875
@pradeeworld4875 3 жыл бұрын
Sir super ra explain panringa
@sivanandanmohankumar5284
@sivanandanmohankumar5284 4 жыл бұрын
Sir neenga semmaya teach pandringa
@randomvideostamil928
@randomvideostamil928 3 жыл бұрын
Wow nice explanation sir appreciated your efforts ❤️
@sivamayamaudio7432
@sivamayamaudio7432 4 жыл бұрын
Super sir. Iam following your instructions now.
@sivamproductions-agarbathi717
@sivamproductions-agarbathi717 4 жыл бұрын
Super Explanation Brother - Thanks
@manju6678
@manju6678 6 жыл бұрын
Sir. I understood clearly your videos. Thank you for that. But excel sheet la nenga formula use panum podu ena podriga nu clearly paka mudiyala enum zoom panuga or else clearness venum.
@tutorjoes
@tutorjoes 6 жыл бұрын
Surw
@sathyapriya1110
@sathyapriya1110 4 жыл бұрын
Bro.. suppose we use a grade O, A+,A,B+,B,C,D,F... Formula will be sequence... It's very difficult to do... Dedicated some video of this sequence of grade
@kameshwaran8960
@kameshwaran8960 4 жыл бұрын
Hi bro.. I need help.. I need to prapare one report.. In that report I have two columns "LAST week status" & "Today status" based on this both I have to prepare one final status... For example last weeks status is completed and today status is also completed then my final status will be show like completed.. If incase my last week status is pending and this week it as completed then my final status will be completed.. Kindly advise how to set the if formula on this???? Awaiting for your response
@harisudhan652
@harisudhan652 5 жыл бұрын
Good sir put a video on Embeded function in Ms-Excel
@sathyanarayanansatagopan9069
@sathyanarayanansatagopan9069 3 жыл бұрын
Sir, please explain date wise debit and credit total in two columns and balance in next line.
@VijayRaj-ij4on
@VijayRaj-ij4on 5 жыл бұрын
super bro, good explain and very useful for me
@uvancreationz1624
@uvancreationz1624 3 жыл бұрын
Superb sir
@vijays5971
@vijays5971 3 жыл бұрын
Tq sir..super
@AnbarasuAnnamalai
@AnbarasuAnnamalai 5 жыл бұрын
Good and easy to follow for the beginners also.
@dhanukumar1125
@dhanukumar1125 3 жыл бұрын
Nice class sir
@sharmi4001
@sharmi4001 5 жыл бұрын
Super sir. But condition la I4 na 4th row LA iruka column Ku matumthan varuma
@sharmi4001
@sharmi4001 5 жыл бұрын
Neenga I4 nu tharinga but Athu yepadi i13 varaiku condition check panuthu?
@sathishkumarshankar2003
@sathishkumarshankar2003 4 жыл бұрын
Sir, eppo a grade and b grade varaikum if command podinga suppose d grade vantha same formula la continue panna mudiumma, na appadi panni pathen varala, sr pls explainExample: =IF(N3="PASS",IF(AND(K3>=90,K3=70,K3=50,K3
@safreenumar6101
@safreenumar6101 5 жыл бұрын
Mashallah sir very good explanation
@technoshere9743
@technoshere9743 6 жыл бұрын
Very good thank you
@rubab8359
@rubab8359 3 жыл бұрын
Thank you sir
@balamuruganbalamurugan-i8q
@balamuruganbalamurugan-i8q Ай бұрын
Bro beginner class 1,2,3,4,5,6,7,8 ena lit no kudungal
@sanjayk1286
@sanjayk1286 3 жыл бұрын
VERY GOOD
@RANAND-gf8qo
@RANAND-gf8qo 5 жыл бұрын
Nice leacture sir
@samuvelraj3667
@samuvelraj3667 6 жыл бұрын
Supr sir nice explanation
@rameshg8237
@rameshg8237 2 жыл бұрын
Tq sit
@gnanakumar4914
@gnanakumar4914 4 жыл бұрын
How many if conditions can be put in an if condition?
@mohamedkhanmydeen7372
@mohamedkhanmydeen7372 4 жыл бұрын
Four class test mark irukku. Athula highest two mark a add pannnanum excel a. Please சொல்லுங்க
@marriyanmahesh5930
@marriyanmahesh5930 6 жыл бұрын
How to your voice clearly? Any application use it?
@sairam3809
@sairam3809 5 жыл бұрын
Sir for me aptitude test iruku athula ms Excel iruku so kindly which is important to read sollrangala for test
@vshruthi5920
@vshruthi5920 4 жыл бұрын
I have a data related to daily deals(Monday to Thursday is having deal i.e offers, for this week days I want to get the result as Y and for Friday and Saturday, the result should be N). I also have a column of dates and days of the orders placed. I want to know the formula for this. Please help me sir.
@tutorjoes
@tutorjoes 4 жыл бұрын
Check out our latest complete formula tutorial it's help u
@vshruthi5920
@vshruthi5920 4 жыл бұрын
@@tutorjoes ok I'll try. Can you give me your mail address or phone number to ask more doubts
@annakkilisamayal9911
@annakkilisamayal9911 4 жыл бұрын
HI SIR HOW TO GIVE GRADING BY USING ONLY THE AVERAGE.
@nelsonjesus9257
@nelsonjesus9257 5 жыл бұрын
Really good ...
@deepanmuthukumar
@deepanmuthukumar 4 жыл бұрын
Thanks
@aakashak2966
@aakashak2966 4 жыл бұрын
Semme sir tq sir 😍
@sathyaspace
@sathyaspace Жыл бұрын
=IF(H2="PASS",IF(AND(G2>=90,G2=80,G2
@vivek5147
@vivek5147 6 жыл бұрын
Thanz sir
@mohammedmafas3454
@mohammedmafas3454 6 жыл бұрын
good sir
@mohammedfaisala6143
@mohammedfaisala6143 4 жыл бұрын
Sir ippa ennada friend abu Dhabi la irukaru data processing procurement office work pannuraru purchase order and stock order Excel la pannuraru athu eppadi sir konjam solla mudiyuma.
@tutorjoes
@tutorjoes 4 жыл бұрын
You can see our excel playlist
@jesmancruz4057
@jesmancruz4057 5 жыл бұрын
Super sir
@balapadmavathi7464
@balapadmavathi7464 5 жыл бұрын
Super 😎
@sylajam5345
@sylajam5345 4 жыл бұрын
Sir in day 3 class last topic over all% I got wrong ans sir its came like days order what can I do sir
@tutorjoes
@tutorjoes 4 жыл бұрын
Show ur error
@Smartbirds4860
@Smartbirds4860 6 жыл бұрын
if and countifs orey formula va epdi podaradhu sollunga..pls
@tutorjoes
@tutorjoes 6 жыл бұрын
Not same countifs only to count records and if statement we can perform many tasks
@aswinisiva1174
@aswinisiva1174 3 жыл бұрын
if (14 yen podurenga sir
@mohammedfaisala6143
@mohammedfaisala6143 4 жыл бұрын
Hi sir
@svinodhini3008
@svinodhini3008 3 жыл бұрын
IF condition la I4 nu erukula athu ennathu anna
@hajasahib8943
@hajasahib8943 5 жыл бұрын
Hi bro I have one doubt, how to split sheets, date wise
@tutorjoes
@tutorjoes 5 жыл бұрын
Can you explain brief about your doubt
@hajasahib8943
@hajasahib8943 5 жыл бұрын
@@tutorjoes அதாவது என்னிடம் ஒரு எக்சல் சீட் இருக்கு அதில் சேல் ரிப்போர்ட் தேதி வாரியாக உள்ளது அதை தேதி வாரியாக அடுத்த சீட் ல ஸ்பிலிட் பன்னனும் pivot table ல பன்னலாம் அது இல்லாம வேர ஏதாவது வழி இருந்தால் தெரிவியுங்கள்,நன்றி.
@ganeshs9341
@ganeshs9341 4 жыл бұрын
HI BRO ADHAA LAST RESULT MATHUM VARALAA ABC GRADE LAAAAAA ERROR NU VARUDHU BRO....
@vanithanarayanarao339
@vanithanarayanarao339 4 жыл бұрын
Thq, + - * / இவை நீங்கள் எங்கே இருந்து எடுக்கிறிங்க
@balamuruganbalamurugan-i8q
@balamuruganbalamurugan-i8q Ай бұрын
Ok
@sbnsaravana2882
@sbnsaravana2882 6 жыл бұрын
Bro how to contact you
@kodairoadkannan
@kodairoadkannan 5 жыл бұрын
eppo greater than ellama two or three name eruntha athukku yappadi formula pannuvathu
@tutorjoes
@tutorjoes 5 жыл бұрын
You can use and or function . Send me some samples i will do for u
@kodairoadkannan
@kodairoadkannan 5 жыл бұрын
@@tutorjoes nan trade pannuran. athula sell, buy, short, long, use pannanum. sell, short onnu, long, buy onnu, ethukku formula pannunum bro
@gopalarju567
@gopalarju567 Жыл бұрын
I have a doute
@mohammedmafas3454
@mohammedmafas3454 6 жыл бұрын
sir excel class mudiya android start pannunga enakku next month android class start
@tutorjoes
@tutorjoes 5 жыл бұрын
Sure
@baraniplayz2161
@baraniplayz2161 6 ай бұрын
Formula just I didn’t understanding
@sugubinni3144
@sugubinni3144 5 жыл бұрын
How to build banking software What should I need to learn first, second, third and etc stages please Give your suggestion
@tutorjoes
@tutorjoes 5 жыл бұрын
Bankning means or other financial software's
@sugubinni3144
@sugubinni3144 5 жыл бұрын
Sir I need to develop core banking software sir please suggest me what to do and for it.
@pradeeworld4875
@pradeeworld4875 3 жыл бұрын
Unga whatsapp number sollunga sir
@MM-ye3zq
@MM-ye3zq 4 жыл бұрын
Good teaching sir
@kesavans1830
@kesavans1830 2 жыл бұрын
Anna tq very much 😘
@balamuruganbalamurugan-i8q
@balamuruganbalamurugan-i8q Ай бұрын
Ok
@arockiadarwin8026
@arockiadarwin8026 2 жыл бұрын
bro adutha if condition kudutha too many argumentsnu varudhu
@kathirj6300
@kathirj6300 6 ай бұрын
Yes bro
Relative|Absolute|Mixed References Microsoft Excel 2016 in Tamil
7:57
Tutor Joe's Stanley
Рет қаралды 97 М.
SUM|COUNT|COUNTIF|MAX|MIN Microsoft Excel 2016 in Tamil
10:29
Tutor Joe's Stanley
Рет қаралды 211 М.
REAL 3D brush can draw grass Life Hack #shorts #lifehacks
00:42
MrMaximus
Рет қаралды 11 МЛН
Кәсіпқой бокс | Жәнібек Әлімханұлы - Андрей Михайлович
48:57
哈哈大家为了进去也是想尽办法!#火影忍者 #佐助 #家庭
00:33
火影忍者一家
Рет қаралды 127 МЛН
IF Or Formula in Excel in Tamil
13:03
Endless Knowledge
Рет қаралды 45 М.
VLOOKUP without #N/A error in Microsoft Excel 2016 in Tamil
10:19
Tutor Joe's Stanley
Рет қаралды 77 М.
Paste Special features in Microsoft Excel 2016 in Tamil
7:36
Tutor Joe's Stanley
Рет қаралды 56 М.
Top 25 Shortcut Keys in Microsoft Excel 2016 in Tamil
13:54
Tutor Joe's Stanley
Рет қаралды 71 М.
IF And Formula in Excel in Tamil
8:12
Endless Knowledge
Рет қаралды 338 М.
COUNTIF formula in excel in Tamil
6:54
Endless Knowledge
Рет қаралды 407 М.
REAL 3D brush can draw grass Life Hack #shorts #lifehacks
00:42
MrMaximus
Рет қаралды 11 МЛН