Ye ek video Excel AND,OR Formula ke sare confusion dur kar dega | Excel Formula
HTML-код
- Опубликовано: 27 сен 2024
- 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.
Attend Satish sir's Online Webinar Free: courses.skillc...
#exceltricks
#ifformula
#ifand
#ifor
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Course Website :bit.ly/skill_c...
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...
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
Telegram channel: telegram.me/le...
------------------------------------------------------------------------------------------------------------------------------
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 RUclips 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
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
Tussi great ho
sir aap bhaut acche sai example dete ho osm sir 😍😍😍😍
well simpliefied with good illustrations.
Buhat acha samjhaya aap ne thanks😍😍😍🥰🥰🥰
Very well explained sir🙏❤️
Very well understood sir thank for this explanation
Very nice video 👍👍👍👍
Great going
Very well explained sir ..😊
Awesome class bhai ❤
Full of knowledge
Good teach
Thank u sir🥰🥰🥰🥰🥰🥰
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
Thank you sir ji 🙏🙏🙏
Most welcome
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 Sir.
You are most welcome
Thank you so much ! 🙏
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)
Excel Me ek hi cell mujhe do formula lagana hai-1.Agar starting date aur end date malum hai to dono ke beech ki time DD.MM.YYYY formate me.2.Aur yadi sirf starting date hi keval malum hai to starting se today tak ki time DD.MM.YYYY formate me kaise karen?
Waiting for your response
Sir agar for example any 4 documents me se 2 compulsory ho to konsa use kre please bataiye
Really good
Thank you! Cheers!
Or ka kam if me bhi ho skta hai kya sir.. only sales amt important hai greater then 1lac
सर नमस्ते.. सर एक्सेल शीट फाइल path अगर मैनुअल चेंज करते हैं तो कनेक्शन फाइल से कनेक्शन हट जाता है.. तो कनेक्शन हटे नहीं.. अपडेट अपने आप हो जाए तो कोई विडिओ लिंक देदो. Solutions चाइये
Advance excel new video please
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()
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 का इस्तेमाल कर सकते है।
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.
Is case may nested if bhy use karsakty hy?
As nested if and and function may difference kya hy?
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 unfortunately this app doesn't work in our country Pakistan 😢😢 i am beg fan and student of you dear sir fromm Pakistan.....
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
💙💙💙
❤
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)
Sir aapk ka app me enter nahi hoparaha hai
Sir mere ko advance exel ka batch lena h kha se lu
2
😂😂😂😂 nice
EK hi baat ko baar baar kyo repeat kar rahe ho bhai
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
Too much graphic bro
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)
Thank you so much sir
Keep watching
PLEAES RESOLVE BY IF FORMULA
ID DATE RESULT
1001 25-08-2024 1
1001 26-08-2024 2
1001 27-08-2024 3
1001 28-08-2024 4
1002 29-08-2024 1
1002 30-08-2024 2
1003 31-08-2024 1
1003 01-09-2024 2
1003 02-09-2024 3
PL SUGEST "IF" FORMULA FOR RESULT AS 3rd column
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.
Hello Sir. Nepal ke liye vi hai kya certificate. Reply me.
🎉🎉🎉
Guruji राधे राधे, एक क्वेरी सॉल्व कर दीजिए, एक कॉलम में बहुत से डुप्लीकेट स्कूल के नाम है, तो मैं चाहता हूं कि , दूसरे कॉलम में उसके सामने, स्कूल की संख्या लिखी आ जाए की, चार है, और नीचे की row blank रहे, सिर्फ एक बार लिखा आए 4, और फिर दूसरा स्कूल 10 बार है तो सिर्फ एक बार 10 लिखा आ जाए, ऐसा गर बार हो qk बड़ी लिस्ट है । तो कोई फॉर्मूला बताइए। Thanks ॐ
आप countif का फॉर्मूला यूज़ करे हो जायेगे
Student data में boy, urban, gen एक साथ हो तो A टाइप हो, boy, urban, sc हो तो B टाइप हो, boy, rural, sc हो तो c टाइप हो, फॉर्मूला बतायें प्रैक्टिकल के साथ।
Sir aap SAP Kyou nahi padhate hai please🙏🙏SAP Bhi padhaye
Guru dev ho app❤ thank you apse bohot kuch sikha and apply vi kiya ❤
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? ?
First comment
Pls make a video on is error function
Hy my dear sir aapse request h sir aap please app ko iPhone k liye bhi lonch kre please 🙏🏻
ITNI ASANI SE SAMJA DIA KIA BAT HAI JANAB ECXELLENT.
I have purchased course but I don’t get practice file please help me
Data kuch bhi nahi dikra Sir wo aapko hi dikra
God tussi great ho awesome
Keep watching the new videos I am uploading.
Nice video
How to get practice file
Thank you so much sir ❤
superb teaching skill sir
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)
Thankyou sir
Thank you so much 😀, Keep watching the new videos I am uploading and click on this link.(ruclips.net/video/e_lb0FCAZ24/видео.html)
sir i want to take premium course pls provide your contact for payment
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
Congratulations on your first 314K followers, may you reach 500K soon. 💖
Thanks and welcome🤩🤩🤩🤩🤩🤩