Thank u very much for the commission formula I saw 10 videos they just said only about met not met pass fail etc only alphabets But numbers That is commission u daud Thank u it helped me calculate income tax
Happy to hear that you liked the video!! Don't forget to link, share and subscribe to the channel for this kind of interesting and knowledgeable video. 🙂
Thank you Ripon Dey!!! I believe you will like the below videos on IF formula also: IF - AND - OR : ruclips.net/video/VQwi7-iRqLk/видео.html Nested IF + AND : ruclips.net/video/Ng3rcSKWV4E/видео.html IF Formula + Other Formulas : ruclips.net/video/ct4g0KwgzDA/видео.html
Glad to hear that! I believe you will learn more advanced conditions from this video also - ruclips.net/video/VQwi7-iRqLk/видео.html . Don't forget to like, share and subscribe. 🙂
Dear Sir, I am working in a pesticide company and have bulk data to calculate monthly working on Cash Discounts with respect to payments collected in day-wise credit notes. Hence, if possible make one video on the same.
Praful, if possible, please share your sample data at support@mdatafinnovatics.com with your challenges. We will try to create a video on the same accordingly!
Imax, please share your file via email. If we think that your query will be beneficial for multiple users, then we will definitely make a video on that!
Very interesting video sir, my question is how can we use the item Name and it's rate from a different worksheet by using item code by typing item code manually.
Good morning sir, ek sheet m stock hai mujhe use other sheet per ik range m stock qty. Chaiye example 1st column 0, 2nd 1-5, 3rd 6-100 kay ye posible hai sir please help
Vinod Ji, please share your excel data first, and only then we will be able to advise you. You can send us an excel file with all of the details to support@mdatafinnovatics.com.
You can download the file from here - docs.google.com/spreadsheets/d/1pOkYiAJUjh5CvDG0UHpQg4KkFjAIQSAA/edit?usp=sharing&ouid=112506439037339224674&rtpof=true&sd=true
Thanks. We have shared the link in the description. Please check. You can download the files directly from this link - www.mdatafinnovatics.com/RUclipsVideoAttachments/
Sir, You can color your data the way you want by using conditional formatting, which we have already presented in a video. But, we will try to create a another video to color the data by Green and Red color.
Sir, you will soon see a video showing how to use Excel in the stock market for analysis. So, stay tuned and subscribe the channel for more knowledgeable videos. 👍
@@MDataFinnovatics Exactly You Commented What I Wanted Actully I Made One Excel Sheet and Pull Data Directly From NSE , i Want if PCR Ratio is More Than 1 to 1.2 No Trade , Between 1.2 to 1.4 Buy , Below 1 Sell Buy Colour Green , Sell Colour Red , No Trade Colour Orange , Please Share Your WhatsApp Number ..... I Have Knowledge Of Share Market , We Both Can Earn Lots Of Money Using Our Mind
Please refresh the page and try again the file is still there. If still you are not able to get the file then share your email address we will send an email to you!
I need a help. I have an attendance sheet which contains P, W, A, H in list P should indicate Present W -- weekly Off A -- Absent H -- Half Day How should I make that formulae
You can use =IF(A1="P","Present",IF(A1="W","Weekly Off",IF(A1="A","Absent",IF(A1="H","Half Day","")))) formula for your above query. You can use vlookup formula also.
Hello , Can we make a one equation for multi conditions like the following :- - if someone have data within a couple of months (date of visit - weight- a score) we need to find out if he acheived this score or no within 30 days OR if his weight decreased by a specific percentage within 30 days
Yes, you can apply multiple conditions in the formula. I think as per your requirement you can use IF formula with AND & OR formulas. Watch this video - ruclips.net/video/VQwi7-iRqLk/видео.html. I hope you will get your answer. If not, then you can share your query with the excel file with us.
Ek data hai, hamare pass fixed vehicle hai 12 ghante ke liye or yadi wah 12 ghante se jyada chalta hai to agle 12 gahnte k lie OT hoga, fir uske agle 12 ghante fix hoga is tarah se o gadi chali hai 400 ghante to isme kaise apply hoga formula? Need help i am stuck from last two days.
Mishra Family, iske liye aap ek table create karlo jisme jitne bhi scenarios hai wo mention karlo like 0 to 12 ghante ke liye ye hoga, 13 to 24 hours ke liye ye hoga and so on. And then is table se aap vlookup laga lena.
There is no need of AND formula. AND we use when we have more than 1 condition at a time. So, here you can simply use Nested IF which means Multiple If formulas.
YOU TOLD HOW A FORMULA IS FORMING WHICH MOST VIDEO DONT TELL LIKE YOURS. PLEASE also MAKE VIDEO ON WHY AND WHEN WE USE "" +1 _1 ? * , comma etc. and many more AND WHAT IS THEIR MEANING IN THE FORMULA. please definitely make one
Sir if I have to give HRA according to the level of the employee and there are 8 level in my office I have to use IF formula 7 time same as condition 3 Am i right Thnx in adv 🙏🙏
Yes, if you have 8 conditions, you must use the IF formula 7 times. However, it is also dependent on the type of condition that you have. If your condition is in text format, you can use the VLOOKUP formula instead, which will make the formula shorter.
If you wanna use "And" formula along with "If" Formula it will be bit lengthy because here we need 3 outputs (Excellent, Good, Average). So, nested If is the best solution here.
I Want online help for using, if condition In a chart I have villages in column "A" I have Class in Coloumn "B" I have van fee rates in column "C" Not I want to use it as there are approx 30 villages and van fee is differ for class 6-8 and 9-12 in the village
Respected Sir, I am working in Postal Department, I Have a data based on which I have to calculate commission to employees, Here they prepare manually and submit , Can You Help to Prepare Excel file for calculations of commission.. I will be very Grateful 🙏 I have all the rule and conditions , Percentage rate of commission that can be required for preparation of excel... Please
Hi Vakeel, You can take a reference of Column numbers instead of A to Z text values. For example you can use Column number 1 to 8 for A to H column and 9 to 26 for I to Z column. Use "=COLUMN()" formula.
Always remember that if you have condition from single column then you can directly us IF formula. But if you have conditions from multiple columns then we need to use AND, OR formulas also. Watch this video - ruclips.net/video/VQwi7-iRqLk/видео.html to get more clarity how to use both formulas together as per your query.
Satvinder, could you please tell us in details exactly kya samajh nahi aa raha hai aapko, so that we will try our level best to explain you in detail!!
Hi Amar, There is no specific formula as per your requirement but you can customize the formulas. You can use "=A1+(7-WEEKDAY(A1)+4)" formula to get the next Wednesday where A1 is the cell which contains the date. In the same way you can customize for Saturday also. Please do subscribe the channel and share the videos if you like!
हेलो सर, मुजे एक फार्मूला सिखये मुजे तारीख वाईझ हर एक बंदे के अलग अलग चीझ सेल की टोटल है उसमें मुजे जो मैक्सीमम सेल है उसी बंदे का नाम सो करे इसी प्रकार के पोर्मूले की जरूरत है।
अगर कोई बच्चा सभी विषयों में 0 नम्बर लाता है तो उसे absent दिखाना चाहिए और अगर कोई बच्चा एक भी विषय में 17 से कम अंक लाता है। तो उसे फेल दिखाना चाहिए और सभी विषयों में अगर 17 अंक या इससे ज्यादा अंक लाता है तो पास दिखाना चाहिए क्या फार्मला लगाया जाए बताए
Call us at +91-9354674901 for
Advanced Excel LIVE Training,
Excel Automation, Excel Dashboards, and Power BI assistance. 😀😀👍
How much it cost? i am interested
JazakAllah sir tomorrow I have my IT business paper, it really helped me JazakAllah
Hi soniashafi9682 , I am really happy that our videos are helping you in your paper. Thanks for watching our videos!
solved my problem in a minute, thank you!!
You're welcome Manav Caculo!
Thank u very much for the commission formula
I saw 10 videos they just said only about met not met pass fail etc only alphabets
But numbers That is commission u daud
Thank u it helped me calculate income tax
Happy to hear that you liked the video!! Don't forget to link, share and subscribe to the channel for this kind of interesting and knowledgeable video. 🙂
Very clear explanation thanks for sharing
Glad it was helpful!
Excellent sir. Nice discription, very important
Thank you Niraj Borkar!
आपका समझाने का तरीका बहुत सुंदर है
Thank Sanjay ji!
EXCELLENT WITH DEPTH
i have been trying to do condition 3 from a month or more today i got got the clue of the same . THANK U SO MUCH SIR🤗🤗😀😀😀💯💯
That's really great! Thank you for watching the videos and your support!!
Really good teaching 😊
Thank you Shubham!
Very nicely elaborated thanks it's worthy
Thank you, Prashant Mishra.
Well explained, thanks a lot sir🙏
Very nice.. Keep up the good work
Thank you shobz!
Awesome Sir..thank you :)
Your welcome Rohit Jadhav!!
perfect and excellent your video👌
Thank you Lavanya!!
Nice video sir ji
Thank you Manoj Chaursia!
good work,if+vlookup was good
Thank you Ripon Dey!!! I believe you will like the below videos on IF formula also:
IF - AND - OR : ruclips.net/video/VQwi7-iRqLk/видео.html
Nested IF + AND : ruclips.net/video/Ng3rcSKWV4E/видео.html
IF Formula + Other Formulas : ruclips.net/video/ct4g0KwgzDA/видео.html
Great👍
Very helpful
Thank you Adamya!
Thnkeu so much sir🎉🎉
Thank you!
Simple and greAt explain
Thanks Suraj Bisht!!
Thanks a lot sir
Thank you Lavesh Ghadi!
Excellent video
Thank you very much Shahz!
excellent boss
Thank you Sachin..
Well done sir.
Thank you Abdul!
Hello, your way of teaching is superb sir n how you explain the concept, it will really help me a lot
Thank you so much 👍👍👍👍👍
Varsha, thank you for your comments. Don't forget to subscribe and share the videos with your friends!
Thank you for good knowledge!
Your welcome, Charan Salve. Don't forget to share and subscribe the channel!!
Superb! Just wow!
Thanks a lot Leena!
New learning from your Video sir. Thank you.
Thank you!
Cool vedio sir or bnayeyaii 👍
Thanks and sure
Well explained
Thanks Kashif!
Helpful for me..thanks 👍
Your Welcome MS creater!!
Thanku sir 👍👍👍👍
Your Welcome Baker Vai!!
excellent
Thank you Debolinadewanghosh!
Thanks, this helped!
Excellent sir .. thank you so much
Thank you Rachana Charan for liking the videos!
Excellent Sir...
great video with excellent explanation
Thank you for your support!
Very helpful sir 😊
Thank you!
Superb
❤️❤️ great
Thank you Dk Boss!
Very well explained 👍
Thank you 🙂
Gr8 learnings for all
Thank you Sir...
thanks man, i learned condition 3 and it will help me alot
Glad to hear that! I believe you will learn more advanced conditions from this video also - ruclips.net/video/VQwi7-iRqLk/видео.html . Don't forget to like, share and subscribe. 🙂
Nice and helping Video
Thanks. Subscribe the channel for more interesting videos. Don't forgot to share with your family and friends. 🙂
can you help please on multiple rows repaet value and another column some critical data
Hi Umakanta, Could you provide some examples so we can create a video accordingly?
Super Sir
Thanks!!
Dear Sir, I am working in a pesticide company and have bulk data to calculate monthly working on Cash Discounts with respect to payments collected in day-wise credit notes. Hence, if possible make one video on the same.
Praful, if possible, please share your sample data at support@mdatafinnovatics.com with your challenges. We will try to create a video on the same accordingly!
Thank you Dear 😊
You are welcome Dear!!
Hello sir can u plz make a video of making marksheet or grade sheet of a school or college. I will provide the field required to create marksheet.
Sure Amit. Please share your data and requirement. We will try to create a video on the same.
@@MDataFinnovatics ok sir i will share a marksheet for this.
@@MDataFinnovatics sir i had mailed you a query regarding sum function
Kindly look in that regards
Sir offset ke upar bhi ek video bana do
Okay. We will create a video on offset very soon!!
amazing video sir , I have a sheet can you please make a video on it I can mail you and please explain to us..that will be very helpfull..
Imax, please share your file via email. If we think that your query will be beneficial for multiple users, then we will definitely make a video on that!
Wow sir good initiate mujhe bhi sikhna h
Thanks...
Best video
Thank you Priyanka!!
Sir tell me we can add product coloum in main data.
Abdul, You can add any column in the data. This is the beauty of excel.
Very interesting video sir, my question is how can we use the item Name and it's rate from a different worksheet by using item code by typing item code manually.
MAAMIR, you can simply use VLOOKUP formula!
Good morning sir, ek sheet m stock hai mujhe use other sheet per ik range m stock qty. Chaiye example 1st column 0, 2nd 1-5, 3rd 6-100 kay ye posible hai sir please help
Vinod Ji, please share your excel data first, and only then we will be able to advise you. You can send us an excel file with all of the details to support@mdatafinnovatics.com.
Explained very well Thanks
Thank you!
Sir will u plz make this data available to us
You can download the file from here - docs.google.com/spreadsheets/d/1pOkYiAJUjh5CvDG0UHpQg4KkFjAIQSAA/edit?usp=sharing&ouid=112506439037339224674&rtpof=true&sd=true
Sir one employee half day present and half day absent then how to calculate the employee attendance sheet formula sir
Hi Yagna, I didn't get your query. Please share your query with the excel file so that we can give you the proper solution.
truly worthy, excellent work
Thank you!
Nice and good job. Put excel practiced files in the description.
Thanks. We have shared the link in the description. Please check. You can download the files directly from this link - www.mdatafinnovatics.com/RUclipsVideoAttachments/
Very nice
Thanks Harish Pardhan!
Can You Please Make a Video
If Met Cell colour Green and If Not Met Cell Colour Become Red
Sir, You can color your data the way you want by using conditional formatting, which we have already presented in a video.
But, we will try to create a another video to color the data by Green and Red color.
@@MDataFinnovatics Ok Thanks
Sir, you will soon see a video showing how to use Excel in the stock market for analysis. So, stay tuned and subscribe the channel for more knowledgeable videos. 👍
@@MDataFinnovatics Exactly You Commented What I Wanted
Actully I Made One Excel Sheet and Pull Data Directly From NSE , i Want if PCR Ratio is More Than 1 to 1.2 No Trade , Between 1.2 to 1.4 Buy , Below 1 Sell
Buy Colour Green , Sell Colour Red , No Trade Colour Orange , Please Share Your WhatsApp Number ..... I Have Knowledge Of Share Market , We Both Can Earn Lots Of Money Using Our Mind
@@MDataFinnovatics Today Date
Knowledge is Power .... Just need Work Togather to Earn Money
Repeat value per vlookup with condition
I cannot access the page to get the file.
Please refresh the page and try again the file is still there. If still you are not able to get the file then share your email address we will send an email to you!
I need a help. I have an attendance sheet which contains P, W, A, H in list
P should indicate Present
W -- weekly Off
A -- Absent
H -- Half Day
How should I make that formulae
You can use =IF(A1="P","Present",IF(A1="W","Weekly Off",IF(A1="A","Absent",IF(A1="H","Half Day","")))) formula for your above query. You can use vlookup formula also.
Hello , Can we make a one equation for multi conditions like the following :-
- if someone have data within a couple of months (date of visit - weight- a score)
we need to find out if he acheived this score or no within 30 days
OR if his weight decreased by a specific percentage within 30 days
Yes, you can apply multiple conditions in the formula. I think as per your requirement you can use IF formula with AND & OR formulas. Watch this video - ruclips.net/video/VQwi7-iRqLk/видео.html. I hope you will get your answer. If not, then you can share your query with the excel file with us.
Ek data hai, hamare pass fixed vehicle hai 12 ghante ke liye or yadi wah 12 ghante se jyada chalta hai to agle 12 gahnte k lie OT hoga, fir uske agle 12 ghante fix hoga is tarah se o gadi chali hai 400 ghante to isme kaise apply hoga formula? Need help i am stuck from last two days.
Mishra Family, iske liye aap ek table create karlo jisme jitne bhi scenarios hai wo mention karlo like 0 to 12 ghante ke liye ye hoga, 13 to 24 hours ke liye ye hoga and so on. And then is table se aap vlookup laga lena.
Can we use "if" & "and" nestex function in condition 3?
There is no need of AND formula. AND we use when we have more than 1 condition at a time. So, here you can simply use Nested IF which means Multiple If formulas.
8:00
YOU TOLD HOW A FORMULA IS FORMING WHICH MOST VIDEO DONT TELL LIKE YOURS. PLEASE also MAKE VIDEO ON WHY AND WHEN WE USE "" +1 _1 ? * , comma etc. and many more AND WHAT IS THEIR MEANING IN THE FORMULA. please definitely make one
Thanks, what if for Condition 3 there are additional conditions? for example there is another similar to the 10k to 15k condition?
You have to use Nested IF(Multiple Ifs) if you have multiple conditions.
Sir if I have to give HRA according to the level of the employee and there are 8 level in my office
I have to use IF formula 7 time same as condition 3
Am i right
Thnx in adv 🙏🙏
Yes, if you have 8 conditions, you must use the IF formula 7 times. However, it is also dependent on the type of condition that you have. If your condition is in text format, you can use the VLOOKUP formula instead, which will make the formula shorter.
@@MDataFinnovatics do u have any basics on vlook up in your channel that will be helpful
You can check these 2 videos -
ruclips.net/video/0diBIwqmQ9k/видео.html
ruclips.net/video/spYxNgQgg-Y/видео.html
You can watch this video ruclips.net/video/v-YMxDMtv8E/видео.html for your query. It will definitely help you.
How to copy and paste when filter is applied.
You can use Ctrl + C to copy and Ctrl + V to paste the data even if there is filter.
in 3rd condition, cant we use "if -and "to indicate "average" comment ?
If you wanna use "And" formula along with "If" Formula it will be bit lengthy because here we need 3 outputs (Excellent, Good, Average). So, nested If is the best solution here.
Mujhe income tax slab fy 2024 2025 if and o formula kaise kare।
Dear sir, thanks for tutorial but you have uploaded wrong file.... please check
Dear Raj, thanks for checking. The file link is correct, go to that particular link and at the bottom of the page you will find the file link.
I Want online help for using, if condition
In a chart
I have villages in column "A"
I have Class in Coloumn "B"
I have van fee rates in column "C"
Not I want to use it as there are approx 30 villages and van fee is differ for class 6-8 and 9-12 in the village
Please share your excel file and detailed requirement at support@mdatafinnovatics.com along with your contact number.
Respected Sir,
I am working in Postal Department, I Have a data based on which I have to calculate commission to employees,
Here they prepare manually and submit , Can You Help to Prepare Excel file for calculations of commission..
I will be very Grateful 🙏
I have all the rule and conditions , Percentage rate of commission that can be required for preparation of excel...
Please
Piyush, Please share your requirement, data and contact number at support@mdatafinnovatics.com. The team will contact and assist you accordingly.
Koi btayega ki 15 se jyada ho to 15 output aaye or 15 se kam h to vhi value output aaye jese 12 h to 12 output iska formula kya hoga
Hi Haru,
You can easily get the desired results by using IF formula. Suppose you have the value in A1 cell then use this formula: =IF(A1>15,15,A1)
SIR..... A-Z TAK KOI ITEM HAI..MAI 1 MINUS KARU TO A-H 1 MINUS HO,H-Z TAK 2 MINUS HO.... YE KESE HOGA?
Hi Vakeel, You can take a reference of Column numbers instead of A to Z text values. For example you can use Column number 1 to 8 for A to H column and 9 to 26 for I to Z column. Use "=COLUMN()" formula.
sir ek hi cell me =if(E12=G10,''G10'') dono fromula kese use kare
Always remember that if you have condition from single column then you can directly us IF formula. But if you have conditions from multiple columns then we need to use AND, OR formulas also. Watch this video - ruclips.net/video/VQwi7-iRqLk/видео.html to get more clarity how to use both formulas together as per your query.
Sir condition 0> nhi samjh aa Raha please reply me back
Satvinder, could you please tell us in details exactly kya samajh nahi aa raha hai aapko, so that we will try our level best to explain you in detail!!
Sir एक ऐसा फार्मूला बताए , जिसमे की कोई भी date लिखे तो वह date अपने next, wednesday या saturday की date में convert हो जाए
Hi Amar, There is no specific formula as per your requirement but you can customize the formulas. You can use "=A1+(7-WEEKDAY(A1)+4)" formula to get the next Wednesday where A1 is the cell which contains the date. In the same way you can customize for Saturday also.
Please do subscribe the channel and share the videos if you like!
@@MDataFinnovatics जी sir
Watch the updated video on how to calculate the next Wednesday. ruclips.net/video/0m-vDeczDV8/видео.html
Bro your video is blurr we are unable to see. Nothing is visible
Please watch the video in high definition, bro.
Your suggestions will be taken into consideration when we produce future videos. Thank you!
MIS banane ki video chahiye
Sure Harish. If we get more comments on MIS then we definitely create a video on MIS!
Can you solve my problem
Please share your problem!
@@MDataFinnovatics your email address
Please share your query at support@mdatafinnovatics.com
हेलो सर,
मुजे एक फार्मूला सिखये
मुजे तारीख वाईझ हर एक बंदे के अलग अलग चीझ सेल की टोटल है उसमें मुजे जो मैक्सीमम सेल है उसी बंदे का नाम सो करे इसी प्रकार के पोर्मूले की जरूरत है।
You can use Index + Match + Max Formula to get the answer.
Mera ak question hai
Sure Monu ji, please ask.
अगर कोई बच्चा सभी विषयों में 0 नम्बर लाता है तो उसे absent दिखाना चाहिए और अगर कोई बच्चा एक भी विषय में 17 से कम अंक लाता है। तो उसे फेल दिखाना चाहिए और सभी विषयों में अगर 17 अंक या इससे ज्यादा अंक लाता है तो पास दिखाना चाहिए क्या फार्मला लगाया जाए बताए
Here you can use Nested IF and Countif formula.
@@MDataFinnovatics उससे नही हो रहा है
Please share your formula how are you using
@@MDataFinnovatics सेंड कर दिया हूँ सर
kaha share kiya hai aapne?
Cj darcl... HR
Don't write the title in English if you are not going to speak it
Saaf nhi dikh raha to kya fayda
Sir, kya nhi dikh raha aapko?
Thankyou so much 😊
Abhay, your welcome. 😊