Ye ek video Excel AND,OR Formula ke sare confusion dur kar dega | Excel Formula
Вставка
- Опубліковано 27 кві 2023
- Ye ek video Excel AND,OR Formula ke sare confusion dur kar dega | Excel Formula
Doston, aaj ke ye video aapko Excel me IF AND,OR Formula ke sare confusion dur kar dega.joki aapko janana bahut jaroori hai.to is video ko pura dekhiye aur aapne office ke dosto ko jaroor share kijiye.
#exceltricks
#ifformula
#ifand
#ifor
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Course Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
------------------------------------------------------------------------------------------------------------------------------
Check our latest blogs: learnmoreindia.in/
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
Telegram channel: telegram.me/learnmoreindia
------------------------------------------------------------------------------------------------------------------------------
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Excel Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My UA-cam Gears :
Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu
Guru dev ho app❤ thank you apse bohot kuch sikha and apply vi kiya ❤
Very well understood sir thank for this explanation
sir aap bhaut acche sai example dete ho osm sir 😍😍😍😍
Buhat acha samjhaya aap ne thanks😍😍😍🥰🥰🥰
Very well explained sir ..😊
ITNI ASANI SE SAMJA DIA KIA BAT HAI JANAB ECXELLENT.
Great going
Thank you so much sir ❤
Full of knowledge
Good teach
Awesome class bhai ❤
Nice video
Thank u sir🥰🥰🥰🥰🥰🥰
Tussi great ho
Pls make a video on is error function
🎉🎉🎉
Or ka kam if me bhi ho skta hai kya sir.. only sales amt important hai greater then 1lac
Thank You Sir.
You are most welcome
Is case may nested if bhy use karsakty hy?
As nested if and and function may difference kya hy?
superb teaching skill sir
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)
💙💙💙
Sir, Apka next video ka Date boldijiye. Appne kafi din bad video upload Kia. Meyto bahut paresan hogaya tha ki sayad appka video Miss hogaya hai. Kindly part number of video it's help to identify part to part.
Thank you so much ! 🙏
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)
सर नमस्ते.. सर एक्सेल शीट फाइल path अगर मैनुअल चेंज करते हैं तो कनेक्शन फाइल से कनेक्शन हट जाता है.. तो कनेक्शन हटे नहीं.. अपडेट अपने आप हो जाए तो कोई विडिओ लिंक देदो. Solutions चाइये
Ohh Annaaa Xlookup ke diffrent uses formula pee iss janam mein hame video milega ki nahi 2mahine se bol raha hun Xlookup or xlookup ke array ke sath video banao.
Thank you so much sir
Keep watching
Thank you sir ji 🙏🙏🙏
Most welcome
Really good
Thank you! Cheers!
God tussi great ho awesome
Keep watching the new videos I am uploading.
Thankyou sir
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)
If a Student gives a Test of 3 subjects and he is "absent" in one subject, then in remark "it should show - Absent".
Could you please make a tutorial on it.
Sir agar for example any 4 documents me se 2 compulsory ho to konsa use kre please bataiye
First comment
Sar iski Ek Aur video laoo Jiske andar if and aur 3 example ek hi Iske andar hun usmein Ek bhi Laga Ho and bhi Laga Ho Aur Bhi Laga Ho
Sir aap SAP Kyou nahi padhate hai please🙏🙏SAP Bhi padhaye
Advance excel new video please
❤
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)
Hy my dear sir aapse request h sir aap please app ko iPhone k liye bhi lonch kre please 🙏🏻
Sir please help.
Example.
If there is 5 in column A then write XYZ and if there is 18 in column A then write ABC and if there is 12 in column A then write pqr If there is 28 in column A then write MNO
Which formula will be used for this? ?
Sir typing course lao tips
Sir mujhe problem ho raha hai aapke download videos ko mein offline nhi access kar pa raha hu mujhe wahi download videos dekhne ke liye mujhe net ko open karke rakhna ho raha hai
apna hindi sudharo kripya
Sir aapk ka app me enter nahi hoparaha hai
Sir mere ko advance exel ka batch lena h kha se lu
How to get practice file
I have purchased course but I don’t get practice file please help me
2
😂😂😂😂 nice
EK hi baat ko baar baar kyo repeat kar rahe ho bhai
Sir unfortunately this app doesn't work in our country Pakistan 😢😢 i am beg fan and student of you dear sir fromm Pakistan.....
EXCEL ME PAITAL SENTECE SE SMALL SENTENCE ME KAISE AYEGA
Lower ka formula lag ke
=Lower(jis cell me ya Jo word/text ko lower me convert Krna h vo cell ko ()isme likhe ke Entre kr do
=Lower(cell b2) Entre
sir 1 qus ka solution lena h apse, ek range h 30 column m jisme 7,8, 8.5,9,9.5,10 value pdi h hmko 9 s uper ki value ko sum krna , jaise 9-10 m 1 , 9-11 m 2
koi bhi iska ans de do,
इसके लिए आप SUMIF Function का इस्तेमाल कर सकते है।
I am placing/writing a formula in cell C1
In A1 - Its EXPIRY DATE
In B1 - Its RENEWAL DATE
=IF(TODAY()>=B1,"SEND RENEW REMINDER","WAIT")
The above formula is working.
Now, I want to apply one more condition in same cell C1 - That if A1 is less than TODAY's date, the result should be "PENDING" and if I write manually (CANCELLED) in A1, the result should be "CANCELLED". Something like =IF(TODAY()
Guruji राधे राधे, एक क्वेरी सॉल्व कर दीजिए, एक कॉलम में बहुत से डुप्लीकेट स्कूल के नाम है, तो मैं चाहता हूं कि , दूसरे कॉलम में उसके सामने, स्कूल की संख्या लिखी आ जाए की, चार है, और नीचे की row blank रहे, सिर्फ एक बार लिखा आए 4, और फिर दूसरा स्कूल 10 बार है तो सिर्फ एक बार 10 लिखा आ जाए, ऐसा गर बार हो qk बड़ी लिस्ट है । तो कोई फॉर्मूला बताइए। Thanks ॐ
आप countif का फॉर्मूला यूज़ करे हो जायेगे
Student data में boy, urban, gen एक साथ हो तो A टाइप हो, boy, urban, sc हो तो B टाइप हो, boy, rural, sc हो तो c टाइप हो, फॉर्मूला बतायें प्रैक्टिकल के साथ।
Sir ji , nice tricks.....
Sir ji ek question:
"I was try to create simple data entry file .
Employee information :
Name /address/gender/Birthday dates/ joining date / Designation / contact number
* Command button
* Click Command button to open
VBA userform
* Fill data in userform
* Save data in Table formats
* Anything serachable box making
(How to data entry using userform for Table ?????????)
Please sir biggest helps for office employees & Database mantain
Mi k
Data kuch bhi nahi dikra Sir wo aapko hi dikra
Too much graphic bro
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ua-cam.com/video/e_lb0FCAZ24/v-deo.html)
Hello sir namaskar me Harsh sonkar form sehore
Mujhe apse ye puchna hai ki agr hmre pass VBA ki file hai or vo password protected hai usme hum kuch bhi change or code nhi dekha sakte bine password open kiy hue tab hum uske code or password ko kese dekhe. Me apko us file ka attachment share krta hu plz share ur email so I attached the file
sir i want to take premium course pls provide your contact for payment