sir ji problem solve kar di aapne , mery ye hi query thi ki agar koi fail hai to uski % kyu show karni aur kyu usko grade assign karni. kitane vds dekh liye kisi ne samjhaya hi nahi but ab samjh aa gya. dhanyawaad guru ji 😇😇
Sir me ne if ka formula use kerky category 1, 2, 3 , 4 nikaly hain jo behteen kam ker reha he, lekin us formula men conditional formula ki madad se men category 1 ko green category 2 ko yelow, category 3 ko pink or category 4 ko red karna chahta jo nhi horeha kindly guide me ?
take the screen shot of sir's sheet from the video. save it on your desktop.. go to data tab>picture from file> pick the saved screenshot > open > screen shot will be pulled to your excel sheet .. from right side system will show you insert data.. enter the insert data .. ola you will get the sheet for practice
Sir, if 1st condition or 2nd condition match than write A1 or A2 please provide formula for this. (any one condition match) write A1 no condition match write b2. please reply.
hi Sir I want to create a calculator in excel vba But i want to operate it with numeric keys instead of mouse 2 Dot should not repeat like 5...6 can you lunch a lecture on it
Sir, Asa koi formula hy K Ek collum me ye Sb adjust ho jye me A add Karon tu 10 marks aa jaen B karon tu 20 marks aa jaen or total me count Ho jaen.... A =10 point B=20 C=30 K... Plzzzzzz
Sir ap mujhe RAM ROM primary secondary memory input output devices...matlab basic of computer seekhaden...agar apne koi video banayee Hui hai toh link bhejden
दिन के नाम के अनुसार परिणाम चाहिए जैसे Monday k liye. Sabji roti Tuesday k liye. Dal chawal Wednesday k liye. Dal roti Thursday k liye. Khichadi Friday k liye. Dal roti Saturday k liye. Sabji roti Please formula banakar bhejo Excel me
@YogesHMehta-wi2ly 57 seconds ago प्रणाम गुरुजी, मुझे एक डाटा में केमिस्ट्री की माप लिखनी है, यह 0.38 से 0.45 के बीच होनी चाहिए, अगर इससे नीचे आती है तो सेल हाईलाइट हो जाए और ज्यादा हो तो हाईलाइट होनी चाहिए, तो कौन सा फॉर्मूला लागू होना चाहिए?
Thanks I got my point with the help of your lucid explanation.
Very fantastic sir
मैने एक्सेल के बहोत vedio देखे लेकीन इससे बेहत्तर अभितक देखा नाही. Thankyou very much. Sir.
sir ji problem solve kar di aapne , mery ye hi query thi ki agar koi fail hai to uski % kyu show karni aur kyu usko grade assign karni. kitane vds dekh liye kisi ne samjhaya hi nahi but ab samjh aa gya. dhanyawaad guru ji 😇😇
Sir, you are great. Your teaching is simply superb. Thanks
Thanks sir if ke sare dout ek hi vidio me clear huye hai
Guruji bahut sara sheekh rahe ha aapke videos se🙏🏻🙏🏻🙏🏻
You explained it very well Manoj sir .
Good explain along with clear voice
Very nice explanation sir
Nicely explained with simple examples
Thank you sir 🙏
I like to learn from you
Thanks sir f
Best trick and Or function
Excellent sir thank u 🙏🏻🙏🏻
Very nice sir thanks
Thanks sir very helpful video sir
Most welcome
❤️❤️❤️
Awesome topics sir
Thanks for liking
Thank you .
Mast topic
Great way to explain
Sir please tell how to sum a column or a row in which a cell has IF formula.
धन्यवाद! सर
🙏🙏
Excellent 👌
Sir, in my system nested if argument available three. How can I apply four or five arguments ?
Sir, kindly provide the rank to passed student only, excluding failed ones
One last missing row, in this video, that is comment. Ab grade toh de diyaa, par comment bhi denaa padegaa last mein.
Sir me ne if ka formula use kerky category 1, 2, 3 , 4 nikaly hain jo behteen kam ker reha he, lekin us formula men conditional formula ki madad se men category 1 ko green category 2 ko yelow, category 3 ko pink or category 4 ko red karna chahta jo nhi horeha kindly guide me ?
Sir, pls provide for practice exercises
take the screen shot of sir's sheet from the video. save it on your desktop.. go to data tab>picture from file> pick the saved screenshot > open > screen shot will be pulled to your excel sheet .. from right side system will show you insert data.. enter the insert data .. ola you will get the sheet for practice
Sir mujhe advance Excel sikhna hai
Manoj Ji,
Ek Excel format me help chahiye. Aapko format mail kar ke kuch discuss karna hai. Kripya apna mail id provide karen. Thank you 😊 😊
sir please make one video for how make QR code generator in ms office
sir one subject me fail to fail ho ,nhi to percentage wise 1st 2nd 3rd dikhaye
Sir, if 1st condition or 2nd condition match than write A1 or A2 please provide formula for this.
(any one condition match) write A1
no condition match write b2.
please reply.
hi
Sir
I want to create a calculator in excel vba
But i want to operate it with numeric keys instead of mouse
2 Dot should not repeat like 5...6
can you lunch a lecture on it
Please share the database prectise sheet
Sir, how to count number of grades obtained by students saperately,?
SIR KOI VIDEO HAI KYA JISME ( , ' " ) in sign ko kyun lagate hai yah samjhya ho, or yah kyun use karte hai
Sir number ke phiche agar manish ka chin laga h to usko sum kese kare
Sir, Asa koi formula hy K Ek collum me ye Sb adjust ho jye me A add Karon tu 10 marks aa jaen B karon tu 20 marks aa jaen or total me count Ho jaen.... A =10 point B=20 C=30 K... Plzzzzzz
sir bracket close karne k bad fail or pass kun, pora likh kar than double bracket close kar den tu
Sir ap mujhe RAM ROM primary secondary memory input output devices...matlab basic of computer seekhaden...agar apne koi video banayee Hui hai toh link bhejden
दिन के नाम के अनुसार परिणाम चाहिए
जैसे Monday k liye. Sabji roti
Tuesday k liye. Dal chawal
Wednesday k liye. Dal roti
Thursday k liye. Khichadi
Friday k liye. Dal roti
Saturday k liye. Sabji roti
Please formula banakar bhejo Excel me
@YogesHMehta-wi2ly
57 seconds ago
प्रणाम गुरुजी,
मुझे एक डाटा में केमिस्ट्री की माप लिखनी है, यह 0.38 से 0.45 के बीच होनी चाहिए, अगर इससे नीचे आती है तो सेल हाईलाइट हो जाए और ज्यादा हो तो हाईलाइट होनी चाहिए, तो कौन सा फॉर्मूला लागू होना चाहिए?
एक विषय 33 है तो F1 दो में हो तो F2 तीन में हो F3 चार में हो तो F4 पाच में हो F5 छे में हो तो F6 33 से जादा हो पास ये फॉर्मुला कैसे लगाये
Please share practice sheet
Sir कुछ चीजे समझ में नहीं आ रही है तो सोचा आपके mob no से बात कर लूं । तो आपसे कैसे बात हो पायेगी ।🙏
video nice but where is download file
Practice file de do
start giving the files so that peopel can practice
Practice file download not available 😂 sir ?
=IF(F3="l.m.v-1","LMV-1",IF(F3=l.m.v-2,"LMV-2",IF(l.m.v-3,"LMV-3")))
SIR YA FORMULA ACTIVED NAHI HO RAHA HAI