on path to complete watching your videos of basic to advance series, baki log isi content ke paise lete hai, jo aap free me seekha de rahe ho sir, with data files to practice. thanks once again.
Sir i am 11th standard student and i have been following you since last year.....you teach very well without any haste ❤️.....but i have been seeing that your channel is growing too slowly.....why ? You deserve million of subscriber 😍😇🙏
Thanks Altaf Sahab .Viewers ko late samajh aayega .ye channel.. Maximum viewer ko sirf tricks aur shorts videos chaiye hota hai.No one want to learn in depth content..Bus kaise bhi kaam ho jaye😊
Sir you are ginius exceptional skills & knowledge of excel good to see you and get to learn is amazing hope we get to learn such an amazing tips and interesting topic of excel to you in future 🙏👍
1st Query Of The MIS Playlist. Sir you are great teacher ❤ but some time I create my Own scenario jiski wajah se mujhe answer dundhne me problem hota hain jaise ye wala :-- Sir agar mujhe 3 me se 2 condition match karani hogi tab kon sa function use hoga "OR" & "AND".
Thanks Rohit Ji itne pyar aur valuable comment ke liye .Basic excel ke pehle.video se seekhna start kijiya.Apko kahin ek rupye bhi course ke naam par lagane ki jarurat nhi hai
2nd example has clarified the real purpose of the formula. Wat if company want to extend credit of those whose credibility is low but deserve a 2nd chance.
Sir, how it can be possible when Nikita has all conditions match, she has all the achievement but your formula didn't worked on it or maybe I didn't understand.
Hello Sir, While using NOT Function in 2nd example of Credit Rating Criteria, is it necessary to freeze the Condition Cell Address while selecting??... and why sir??.
Because he took the main cell above the table (and not the cell within table) that mentions the credit rating in order to make it dynamic .... So every time you change the main credit condition above the table it would not affect the calculation
Hi Sir in 2nd example credit rating 2 logic selection is wrong instead of credit rating 2 you selected sales , Nikita and Abhijeet result will be false in not function
Sir you are really amazing... ☺ But sir i have a query regarding this function.. In 2nd example.. You have passed credit rating2(Question) on behalf of salary but i think it should on behalf of credit rating 2(Condition) Is it right Or Wrong☺ Please reply me ASAP
Hi..Credti rating 2 ko compare bhi usi se karenge gautam,Wrong Selection ho gya hai usme cell ka(salary par click kar diya hoga sayad) apko jo cell value hai jaise credit rating to usse compare,sales ko sales se compare.🙏❤️😆
@@Innozant I can not understand this properly because of this confusion. can you please explain this NOT function with a proper examples like sales quantity and discount related?
Hi Neha , Kindly whatsapp us query ,Will send you all the details and current batch schedule.please find our contact details in our website or lates video Intro.
Agr sr hum Not ka function direct lgate hai to sr vo Kam nhi kr rha pr agr hum formula ke bech me add krte hai not function ko tb vo Kam kr raha hai asa kyuu sr ji ???
Because condition ye hai ke is me ap ne bataya hai ki condition 1 ko condition 1 se or condition 2 ko 2 se or sales ko sales se calculate krenge Kya sr ik bar ap dekh kr bta skte hai ke mai rty hu ya wrong 🤕
Gd evening sir mujhe ek problem aa ri hi mai practice kr ri thi but suddenly pta ni kya hua mai ek cell select kr ri hu toh puri column select ho ri hi mouse se v aur keyboard se v usy thik kaise karu ?
Singh sahab aap sayad naye jude hain Innozant family se,Aapko bata dein ye excel #shorts, tips and tricks channel nahi hai..Complete Tutorial in depth course karaya ja raha hai yahan par. Thanks for your suggestions 😁🙏❤️
Dear .jis bhi playlist ko open krenge usne saare video sequence se rakhe Gaye hai usi sequence me krenge practice.. Isse jyada organize content sayad apko kahin nhi mile
Sir in this vedio in the example of credit extended....you selected credit rating 2 and typed greater than sales of 500000 not credit rat 2.5.... but still no error came...why sir.. please reply
Khan sahab jaise jaise aap series me aage jayenge apko pata chalega ko ye RUclips par banaye Jane Wale tips and tricks video nahi proper in depth complete course karaya gaya hai..jisme topic ko explain karna hota hai jisse learners ko samajh aaye na ki wo formula ko yaad kar le.😀 Thanks for your valuable suggestions.. Happy Learning ♥️♥️ 6.38 minute ka learning video lengthy lag rha hai Khan sahab yahi humlog koi web series dekh rhe hote to time ka pata hi nhi chalta hai na😀
Are guru ji last wala jo apne formula lgaya h isme if(and ke sath not usko jra dhyan se dekhiye apne selection hi glt kiya h apne credit rating ko sales ka criteria me match krwa diya 🤣🤣🤣🤣 vo to aayega hi no credit
@@Innozant waise sir RUclips pe mene itni videos dekhi bt apka smzane ka tarika sbse best h har ek chij ko basic se advance tk koi dout nhi chorte Sare dout clear krte ho
I came randomly came across your channel, really appreciate the explanation style and example. everything is explained in detail. Thank you.
Really means a lot to me.Thanks Keep Learning
on path to complete watching your videos of basic to advance series, baki log isi content ke paise lete hai, jo aap free me seekha de rahe ho sir, with data files to practice. thanks once again.
ruclips.net/video/bWD8dIIqrXc/видео.htmlsi=HW8tS7BOQ1k-Xcih
Sir i am 11th standard student and i have been following you since last year.....you teach very well without any haste ❤️.....but i have been seeing that your channel is growing too slowly.....why ?
You deserve million of subscriber 😍😇🙏
Thanks Altaf Sahab .Viewers ko late samajh aayega .ye channel..
Maximum viewer ko sirf tricks aur shorts videos chaiye hota hai.No one want to learn in depth content..Bus kaise bhi kaam ho jaye😊
Sir tab toh aapko daily 1 jata ji ka short upload karna chaiye 😅
I guarantee, if any one follow these videos judiciously he/she will build strong Excel foundation. These are the same as premium course.
Really means a lot to me
ruclips.net/video/bWD8dIIqrXc/видео.htmlsi=HW8tS7BOQ1k-Xcih
Tq sir , your ms excel class very nice and helpful .. and kindly if , or , and , not, these are function explain in kannada Language...
I don't know Kannad dear
ruclips.net/video/bWD8dIIqrXc/видео.htmlsi=HW8tS7BOQ1k-Xcih
Sir you are ginius exceptional skills & knowledge of excel good to see you and get to learn is amazing hope we get to learn such an amazing tips and interesting topic of excel to you in future 🙏👍
Thanks Pawan Ji..God Bless You..Haan humesha aap seekhte rhenge yhi koshish hogi meri❤️Thanks for being part of Innozant Family dear👍
ruclips.net/video/bWD8dIIqrXc/видео.htmlsi=HW8tS7BOQ1k-Xcih
Nice explanation 😄😄
concept is cleared however not sure where will i use it in my work. Thank you Sir ji
ruclips.net/video/bWD8dIIqrXc/видео.htmlsi=HW8tS7BOQ1k-Xcih
You have such a lovely smile sir, and you are doing a wonderful job.
God bless you sir🙏😊
Thanks Deepak ji❤️
ruclips.net/video/bWD8dIIqrXc/видео.htmlsi=HW8tS7BOQ1k-Xcih
super sir..aapke sabhi concept 😊😊🙏
Thanks dear.
ruclips.net/video/bWD8dIIqrXc/видео.htmlsi=HW8tS7BOQ1k-Xcih
1st Query Of The MIS Playlist.
Sir you are great teacher ❤ but some time I create my Own scenario jiski wajah se mujhe answer dundhne me problem hota hain jaise ye wala :-- Sir agar mujhe 3 me se 2 condition match karani hogi tab kon sa function use hoga "OR" & "AND".
Sir I am in 8th class tomorrow is my exam and you teach very well i can't understand why you used and operator and or operator please reply me🙏🙏
Matlab
Dil kush ho gya sir morning ma ap ka sat phala comments kar rha hu ab video dekna ja rha hu ❤️😂
Thanks Rohit Ji itne pyar aur valuable comment ke liye .Basic excel ke pehle.video se seekhna start kijiya.Apko kahin ek rupye bhi course ke naam par lagane ki jarurat nhi hai
@@Innozant sir mujha if not or and nisted if ka link shar kr sakt ho
Bhai aap ye bataiye ki ek extra function deke sheet heavy karne ki kya zarurat, true ki jagah false aur false ke jagah true ki value dedo na.
2nd example has clarified the real purpose of the formula. Wat if company want to extend credit of those whose credibility is low but deserve a 2nd chance.
Bohot achhe se samjhaya aapne 🙏❤️
ruclips.net/video/bWD8dIIqrXc/видео.htmlsi=HW8tS7BOQ1k-Xcih
What a beautiful start.
Kuch batain such hoti hain🇵🇰❤️
❤️❤️
ruclips.net/video/bWD8dIIqrXc/видео.htmlsi=HW8tS7BOQ1k-Xcih
You are great sir❤️❤️❤️
ruclips.net/video/bWD8dIIqrXc/видео.htmlsi=HW8tS7BOQ1k-Xcih
Really Great
ruclips.net/video/bWD8dIIqrXc/видео.htmlsi=HW8tS7BOQ1k-Xcih
Great knowledge gained by a great personality ❤️❤️❤️
ruclips.net/video/bWD8dIIqrXc/видео.htmlsi=HW8tS7BOQ1k-Xcih
Sir your are great. I think sir when to equel to rating 2 with Sale and Sale equel to rating2. Is it correct sir?
बहुत बढ़िया धन्यवाद साहेब
Thanks Atul Ji.. Happy Learning 🙏❤️
I am happy with video
❤️❤️❤️
What a video tutorial sir🤩🤩🤩🤩🤩......Bravo❤️❤️❤️
Thanks Ritika, Recommend you to start your learning journey from Playlist Basic Excel onwards.. the proceed with Advanced
Kya baat hai sir thank you for this type of video🙏❤💖
Thanks Shwet. Happy Learning
ruclips.net/video/bWD8dIIqrXc/видео.htmlsi=HW8tS7BOQ1k-Xcih
Sir ye flag wale example mein... IF, OR, NOT sab lagana jaruri hai?... Kya sirf NOT nahi laga sakte? Ye thoda confusing lagrai sir.
Absolutely great
Thanks Rajdeep Ji
ruclips.net/video/bWD8dIIqrXc/видео.htmlsi=HW8tS7BOQ1k-Xcih
एक बात समझ नही आई। आपका समझाने का तरीका बहुत ही बढ़िया है। टॉपिक भी बढ़िया होते हैं। पर लाइक और व्यूज बहुत ही कम।
Vijay ji jyadatar audience ko excel jaadoo video jyada pasand aata hai..main sirf padhane ki koshish krta hu..😊❤️
excellent video
ruclips.net/video/bWD8dIIqrXc/видео.htmlsi=HW8tS7BOQ1k-Xcih
TQ..SIR...🙏🙏
Sir,
how it can be possible when Nikita has all conditions match, she has all the achievement but your formula didn't worked on it or maybe I didn't understand.
Sir ne last example me cell ref. hi galat uthaya tha
Sir ji, NOT3 sheet may formula wrong laga diya "CREDIT RATING 2 = SALES" kar diya. Please confirm I am wrong or right
Yes You are right..Video ke flow me galat cell select ho gya tha.. Description me maine bta diya hai aap use theek kar lein🙏
Hello Sir, While using NOT Function in 2nd example of Credit Rating Criteria, is it necessary to freeze the Condition Cell Address while selecting??... and why sir??.
Because he took the main cell above the table (and not the cell within table) that mentions the credit rating in order to make it dynamic ....
So every time you change the main credit condition above the table it would not affect the calculation
@@technoyamraj Thanks for your reply
Hi sir you choose wrong cell in 2nd example ! Credit rating 2!
Ohhh.may be wrong cell choosen.
Kindly acknowledge and rectify it as per your requirement
Check your last example, it was wrong, cause you taken wrong cell address and this is why you get all answer in false value like "no credit"
Yaseen shaab thanks for notify ,Yes wrong cell selected and I already acknowledge this in video description.Thanks for being part of Innozant
Sir function ko yaad kaise rakhe please guide me 🙂
Practice se yaad rehne lgega
Sir You have passed the entry wrong, It should be like this IF(AND(B11>=$B$5,C11>=$B$7,D11>=$B$6), Please Check, Verify and correct It
Yes bro nice observation
Me wahi soch raha mera result wrong kru aa raha hai.
tnx sir
🙏🙏
Sir, you are taken wrong cell reference in last example. Please check once.
Oh .kindly rectify your cell reference,may be by mistake it was opted
Hi Sir in 2nd example credit rating 2 logic selection is wrong instead of credit rating 2 you selected sales , Nikita and Abhijeet result will be false in not function
Hi Abdul,May be the field selection was wrong, Exercise file is there in common link you may download it and start your practice.
Yeah, if selections become correct then there is a condition which is true with 'or' function (row no 20)
sir in which scenario we use xor and not function. could ypu tell.
ruclips.net/video/bWD8dIIqrXc/видео.htmlsi=HW8tS7BOQ1k-Xcih
Sir you are really amazing... ☺
But sir i have a query regarding this function..
In 2nd example.. You have passed credit rating2(Question) on behalf of salary but i think it should on behalf of credit rating 2(Condition)
Is it right Or Wrong☺ Please reply me ASAP
Hi..Credti rating 2 ko compare bhi usi se karenge gautam,Wrong Selection ho gya hai usme cell ka(salary par click kar diya hoga sayad) apko jo cell value hai jaise credit rating to usse compare,sales ko sales se compare.🙏❤️😆
@@Innozant Thanks sir..
Your way of teaching is very nice.. ☺
@@Innozant I can not understand this properly because of this confusion. can you please explain this NOT function with a proper examples like sales quantity and discount related?
@@Innozant isilye sabka result "No Credit" aaya... Thank u for explaing sir :)
Sir, How to Join online Class for Excel.
Hi Neha , Kindly whatsapp us query ,Will send you all the details and current batch schedule.please find our contact details in our website or lates video Intro.
Agr sr hum Not ka function direct lgate hai to sr vo Kam nhi kr rha pr agr hum formula ke bech me add krte hai not function ko tb vo Kam kr raha hai asa kyuu sr ji ???
Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen
CTRD +D Fill down
CTRL+R Fill Right
Wah ! Aap to Shayari bhi karne lage !
Acha ji..Shari nhi..jo man me aata hai us waqt whi baat krte h aap sabhi se dear.
Sr ji is me jb ap 4:51 timings pe aaye to ap ne credit rating ko sale's se link kr diya kya ye sahi hai
Oho..Video ke flow me by mistake le liya hai cell reference galat..aap use theek kr lijiye ..dekh ke hi lag ra hai ki sale ko select krenge..Good 👍❤️
Ok sr ji
Thnq sir
Thanks Gaurav🙏❤️
Because condition ye hai ke is me ap ne bataya hai ki condition 1 ko condition 1 se or condition 2 ko 2 se or sales ko sales se calculate krenge
Kya sr ik bar ap dekh kr bta skte hai ke mai rty hu ya wrong 🤕
Kaunse ques me dear?Not Function simply jo true ho use false me convert kar dega
Sir 6:01 example table mein "and" ke badle "or" chala sakte hai if aur not ke saath?
Humen to dono conditions true chaiye na
Hi sir can I get the pdf.....
i think you have selected wrong please check and correct it when i used this formula my answer was diffrent
Hi Rohinj,Kindly check the cell reference,May be I selected wrong cell Kindly rectify 👍❤️
Sahi se samjha
Aaya nahin samajh Raman ji?Shall i explain again..ya aayaa sahi se samajh?
Sir koi bhi formula excel sheet mein hide kar sakte hai?
If yes then kaise?
Excel security video me bataya hua hai dear..select formula press ctrl 1 -protection- hide
Then reviee tab-protect sheet aur password laga dijiye
If c2>100, d2=30 then e2=10 then e2*1%, or e210 then 2% nhi to nill what is function applied
Please reply
सर आपने Credit Rating 2 में फॉर्मूले में = के बाद Sales(500000) को पास कर दिया है शायद आप से गलती से हो गया है🙏🙏 या मुझे ग़लत दिख रहा है
Video ke flow me galti hua hoga dear.kindky rectify
i think its worth rule
Thanks ❤️
Gd evening sir mujhe ek problem aa ri hi mai practice kr ri thi but suddenly pta ni kya hua mai ek cell select kr ri hu toh puri column select ho ri hi mouse se v aur keyboard se v usy thik kaise karu ?
Ya to koi general settings aapse change ho gya hai ya application hang..Aap system restart kriye.Sahi ho jayega ..Issue phir bhi rhe to batana
@@Innozant maine kia kai baar nai hua ussi vjh se window ve open ni ho ra short cut se question sheets se open krna adh ra baar baar
Dekh bhai bahut log jo excel use krte hai unke pass itna time nae hota, thoda short main bataya kro.
Singh sahab aap sayad naye jude hain Innozant family se,Aapko bata dein ye excel #shorts, tips and tricks channel nahi hai..Complete Tutorial in depth course karaya ja raha hai yahan par.
Thanks for your suggestions 😁🙏❤️
Oo bhai, thoda tameez se...
Jo hame kuchh sikhata hai usse guru bolte hai, guru ki izzat kro🙏
sir 5:03 par aapne range galat le liya Credit Rating 2 main sales le liya
Ohoo..may be by mistake...
This formula is funny mode true is false and false is true
2nd example me formula galat laga hai
App video part by part kyu nahi karate ho...pata hi nahi chalta hai pehle kon sa wala video dekhu
Dear .jis bhi playlist ko open krenge usne saare video sequence se rakhe Gaye hai usi sequence me krenge practice..
Isse jyada organize content sayad apko kahin nhi mile
bahot achat concept tha meri life m
Thanks dear
Last example me credit rating 2 >= Sales kardiya isliye glt output agya but ok
Sir in this vedio in the example of credit extended....you selected credit rating 2 and typed greater than sales of 500000 not credit rat 2.5.... but still no error came...why sir.. please reply
Because he choose wrong cell reference for credit 2 thats why
Sir isme aapne ek condition galat Dali he isliye sabme no credit aaya first time..
Wrong cell select ho gya hoga dearm.rectify it 👍❤️
It's ohk sir it is just for information...baki aapka excel knowledge 👌👌👌👌 superb huge fan
👍🏻👍🏻👍🏻
😍🤓
4:45 function galat h sir ji sale wale column ki value galat uthai h apne ..👍🏿
check kijiye may be wrong cell pick Kar liya hoga..Formula sahi hoga dear
Sir Jo chacha hai wohi bhatija hai or Jo bhatija hai wohi chacha😁
Hahahaha..👍♥️
0:07 are you talking about lawyers....lmao
😊
all good, but aap bahot zada bolkar video lengthy kr dete ho. No need to unnecessary talks.
Khan sahab jaise jaise aap series me aage jayenge apko pata chalega ko ye RUclips par banaye Jane Wale tips and tricks video nahi proper in depth complete course karaya gaya hai..jisme topic ko explain karna hota hai jisse learners ko samajh aaye na ki wo formula ko yaad kar le.😀
Thanks for your valuable suggestions.. Happy Learning ♥️♥️
6.38 minute ka learning video lengthy lag rha hai Khan sahab yahi humlog koi web series dekh rhe hote to time ka pata hi nhi chalta hai na😀
Are guru ji last wala jo apne formula lgaya h isme if(and ke sath not usko jra dhyan se dekhiye apne selection hi glt kiya h apne credit rating ko sales ka criteria me match krwa diya 🤣🤣🤣🤣 vo to aayega hi no credit
Gaurav ji..video banate time flow me galti hua hoga ..kindly rectify as we already mentioned it in videos description
@@Innozant waise sir RUclips pe mene itni videos dekhi bt apka smzane ka tarika sbse best h har ek chij ko basic se advance tk koi dout nhi chorte Sare dout clear krte ho
@@devbhumi7072 Thanks Gaurav ji for your valuable appreciation
Bhut he batamiz type ka function hai NOT. 🤣🤣
Hahah .badtaneez Function ❤️❤️
😂😂😂😂😂😂😂😂😂😂
C11=B7 hona chiya tha, aap nay c11=B6 kar diya
U r right
Sir ji, NOT3 sheet may formula wrong laga diya "CREDIT RATING 2 = SALES" kar diya. Please confirm I am wrong or right
No you are right ...I also asked this now....but still no error came...how's that possible 😮