Information Function in Excel | ISNUMBER , ISTEXT | VLOOKUP With ISNUMBER and ISTEXT
Вставка
- Опубліковано 21 вер 2020
- Learn how to use information function is isnumber and istext in excel
1. Use of Isnumber in Excel
2. Use of Istext in Excel
3. Use of Isnumber and Istext with Vlookup in Excel
Download the Practice Workbook Direct Link
drive.google.com/file/d/1NMAE...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#informationfunctions #isnumberformula#Innozant #exceltricks #istextformula
I really can't believe sometimes in youtube some persons giving such elaborate explanation of every function and that is also free of cost ...and in a sequence basis + assignment file is sharing for us .....
Really huminity ...is being shown by you sir ..
This channel is a heaven for those who r not capable to afford expensive excel ....course .. .like me
Such great explanation of every thing ...
I learn everything of excel fron it ..but due to lack of practice enough face later on problems
But .....sir you r really .....excel hero .
Lots of love from WB 🙏🙏❤️❤️❤️❤️
keep giving us videos so that we can ...learn something extraordinary
Thanks dear for your valuable appreciation.. Really means a lot to me.GOd bless you.. Happy learning..
This channel is 10x better than leila gharani but I guess if english subtitles were available it would have increased the audience
Thanks for your valuable appreciation dear...Keep learning..keep exploring ❤️
Sir ji, AAP ki video say mere Knowledge increase ho rahi hai. THANX
Thanks Pawan Ji .Seekhiye ache se step by steo aur life me aage badhiye
@@Innozant Sir ji, please provide step wise list of basic excel to advance excel
@@PawanKumar-lc3du watch mis learning process video available in playlist upcoming notifcations
Awesome you have amazing skills
Thank_you thank_you thank_you... I am just impressed with your teaching skills and your smile sir... May god give you the strength always to share such a valuable series...Most imp it is 100% FOC
blessed to get you as a teacher.
you are amazing sir thank you so much ❤️
Very useful ❤
Amazing 👏 👏👏
Excellent 👍
Sir This is the best explanation of this function I have ever see. Your every video is a treat to Excel lovers and learners. Thanks you so much sir giving my name in this tutorial. Your teaching is clean.
Thnks Sandeep fkr such a heart touching and beatuful comment ,Mera to din ban jata hai dear apke aise valuablr commnet se..God Bless You.
Awesome.....
Sir thank you very much for the shortcut key alt Def,alt aef,
Thank you sir,
Thanks for sharing, Brilliant knowledge of excel
Thanks Suraj..God bless You dear
Can say only One word
Super Duper EXCELLENT
Thanks Dear
Thanks Sami sahab..Happy learning dear
Very nicely explained!!
Thanks Jaishri.Have a wonderful day
Your smile is more beautiful ❤️ then your vedios sir.
Thanks you sir for explaining using of isnumber and istext.
Thanks Hemant,Hope you like the video and learn from there.
Excelent❤❤❤❤❤
Simple but effective 👍👍
Thanks Ajinkya..Now you are on track again and start learning
Very important questions thank you sir🙏🙏🙏
Thanks Jatin ji❤️🙏
👍
Great video sir
Thanks 🙏❤️🙂
Thank you sir 😊
Thanks dear ❤️
can not believe only 4193 view for such a informative video. very good method to teach tough topics in very easy way. Thank you sir.
Thanks Anil for your love and support ❤️Happy learning
❤️❤️❤️❤️❤️
Excellent sir
Thanks dear
Salute u sir, ..Noone like you.🙏
Thanks Amit Ji❤️🙏
Very effective video sir 🙂
Thanks Dheeraj,Good Morning.hv a nice day.tc🙏
👌🏻👌🏻
Thanks Karan..hv a nice day..Share with your friends
Great
Thanks Pramod❤️❤️
🙏👌👏🙌😊
Good
Yr grt boss
Thanks ❤️
Fantastic sir you doing really good work for excel learner I also recommend my friend to watch your channel and subscribe to watch and learn excel 🙏👍 sir
Can't explain sir... bahut hi bahatreen and effective information..😍😍
Thanks Jitender,Have a great Sunday🙏🙂♥️
@@Innozant Sir mai import export (Logistics) job kar raha hu abhi 2 months se.. kya isme scope hai..? or excel job mere liye dream hai... can you tell me sir
MIS me switch kar jayenge to Acha Hoga .bht Sahi profile hi Jayega Aage ke liye
Thanks sir we wait data validation video with Isfunction good night sir.
Good night satish ji.tc
Nice
Thanks Ram,Good Morning
Bhai same shot key Alt+D+A+F ka daily use karta a raha hu bt abhi tak mera concept clear nahi tha ki ham CSV file me ye short key q use karte hai.
Thank you so much bhai.
Good Morning Alok Ji,Achi baat hai sirf kaam krne se jyada important concept clear ki akhir kyu kar rahe hain.Kuch bhi conceptually seekhiye ki kyu kar rahe hain kya advantage.Umeed hai apkp videos pasand aa rhe honge aur aap usse seekh rhe honge.Tc.hv a nice day❤
Mast hai sir
👌👌
Thnks🙂
Mene pehle advance vlookup series ko complete kara hai.. Uske baad besic sikh raha hu.. Ulta kaam kara hai mene.. 😂😂 lekin sab samjh me agaya😅
Hahahaha...koi nahi...start se hi karna chaiye tha
Sir ishme if ke saat dget bhi use kr sakte hai
nice sir🙏
❤🙏GN
@@Innozant jee sir🙏
Sir array formula me b freeze karna hota hai na?
Hi sir, how to get the respective classes example excel file ? Kindly guide me..
Sir iss video me aapne data validation krane ke liye bola hai aapne kha kraya hai plz reply
Second methud Home tab me Number group me Number format select kr lenge
Please make one video, how you make video .. 🙏🙏🙏🙏plz sir
Haha,Didn't get you.😀
Sir numerical value ko text m kaise convert kiya...aur excel text ko left hand side mention krta h...aur apke data m right hand side mention ho rha h....how??...tell me plz
mere pas 2 sheets hain us main 10 members hain
1 november
2 december
main ye chahta hun ke mere pas 3rd sheet main 1 file hu jis main automatic likha aa jaey ke
jis member ne november ka data submit ni kraya to us member ke samny (not done) likha aa jaey
iska formula btaen
Sir, can we apply DGET in this student and score example?
Yes Shweta,If we want to extract a single record from data set..
Hello Sir I have a question, if an employee work in process "A" for x days and in after that he/she changes his/her process to " B" within the same company. So my question is that how many days he/she worked in A process and in B process & both process in total?Actually I got the the A & B process individual work time but I unable to find out for both process total time. Can I use Sumifs function? Please help in this. Thanks in advance :)
Use sumifs or sum with if and make them array,Try to do at your end if unable to solve it let me know or send your data sheet will solve and revert back to you.
@@Innozant Thank you so much for quick reply. I definitely going to try these functions and get back to you. Thank you so much.
Ok let me know if you are unable to solve it.
Telegram @innozantofficial
It seems Mona is New member of Innozant Family?🙂
Sir ek question hai mujhe WIP report banani hai or data do different sheets pr hai
Bnata uus is topic par video .time dijiye
Practice file of this is not available in your folder
🙆🙆🙆🙆🙆🙆🙆🙆🙆🙆🙆🙆🙆
Thanks Nisha❤❤
sir jaise name emp id ka data chahiye to
emp id emp0001 hai to isnumber chalega kya
Nhi right function se number extract kijiye ydi data ka pattern fix hai to
Advance Data validation video kab load ho jayega
Soon dear,Have patience 🙏
=IF(ISTEXT(A1)AND(ISBLANK(B1),C1-D1,"") Ye formula kaise sajauw , i mean 2 diferent iF function in one cell. I am waiting Your replY
=IF(OR(ISTEXT(A1),ISBLANK(B1)),C1-D1,"")
Ye paas kijiye kaam karega
Sir but it isn't working with the istext function
Why.?
Sir vlookup or hlookup wali vedio delete kar di hai kya apne vo ab show nahi ho rahi hai
Sapna saare hi to play list available hain.koi video deleted nahi hai..aap playlist wise video dekhiye
Hello. I have this formula currently but I want to add to it so if the value is a text and not a number, it enters 0. I don’t want Any non numeric valves but the worksheet it’s getting the data from, has both letters and numbers.
Thanks
=IFERROR(VLOOKUP(B13,INDIRECT(G10&”!B8:D49”),2,0),0)
Hi Ishita you may check either value or text in cell using if(istext) then proceed with further logic you want to apply
@@Innozant I tried that but is bringing the result FALSE for non numeric values. I want the result to be 0 so I can use the value for further calculation
If I use istext, it gives me 0 and if I use ifnumber, it gives me false. But the data it’s pulling information from is a mixed of numbers and letters. So with istext, it gives me 0 for non number values but all the numeric values are now false. Is there a way to use both?
Excellent sir
Thanks Rajkumat jo.Hope you luke the video
Sir, Aap ka padhane ka tarika mijhe bahut accha lag raha hey isi liye me aap ki sabhi vedio ko bahut hi Ryan de dekta hu kyoki mujhe bahut jankari mil rahi hey
Thank
Thanks Raj,Step by step Basic excel playlist onwards seekhiye..apko kahin fees deke seekhne ki jarurat nhi hogi.
Hi sir, how to get the respective classes example excel file ? from google drive.Kindly guide me..
Please find assignment master link playlist wise from video description