This is really good, In every view every one discuss only one formula but u clear my concept with the multiple formula in Thank you so much, I appreciate
Excellent 👍 Sir, attandance sheet me Saturday "A" hone per Sunday bhi "Leave" count ho jaye aur Monday "A" hone per Sunday bhi "Leave" count ho jaye aur Saturday or Monday "A" hone par 3 din Leave count ho jaye aesa formula bataiye.
Thanks. The link is given in the video description from where you can download the excel files. You can get all the files from this Link - www.mdatafinnovatics.com/youtubevideoattachments/.
The formula for 4th question, if we want to add the same complete formula with one more criteria, How to add, l mean, bracket close then we add or comma will work.
Sir agar hum chart banate he row me company name and column me item ke rate Aur agar hame ye dusare sheet me ye result chahiye ki is company ko ye item diya he to uska rate vaha ana chahiye To kaise kare sir
how to Calculate the PR to PO duration based on the followings: If LOA date is available ignore the PO date and calculate the Cycle time from LOA date less RFQ Date (if RFQ date is missing consider the PR Approval Date) Waiting your reply.
If I have some values in one column 0.0, 0.81, 1.25, 2.50, 3.50 but we want print to other column 0 to 0.5 through if condition so plz suggest formula sir ji or any guys
Studypoint, I am not getting your condition. Aap detail me apni condition ko bataiye ya fir agar aapke pass koi excel file hai jisme ye condition hai to usko aap email kar sakte ho support@mdatafinnovatics.com par with complete detail. We will solve and revert you back. Thank You!!
Sir , 01) In-patient = private hospital = form D 02) In-patient = recognized hospital = form B 03) Out-patient = recognized hospital = form D ye tino conditions if formula mein kaise dall sakte hai . Pls guide
Rakesh, you need to use IF & AND formula together to solve your query! If need more clarity on the formula, please share your excel file with detailed query on support@mdatafinnovatics.com
Sir me ne if or and 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 ?
Hallo, im working on an excel sheet that has a column named Overall results. Under this column I have used average function to find the average of each students score(=AVERAGE(F5,J5,K5,L5,O5,P5,Q5) ). My desired outcome is to display conditions "Pass" "Fail" "Refer" on the same column of the Overall performance. I have tried this formular =AVERAGE(F5,J5,K5,L5,O5,P5,Q5) + IF(R34>=85,"DISTINCTION(1)",IF(R34>=76,"DISTINCTION(2)",IF(R34>=68,"CREDIT (3)",IF(R34>=60,"CREDIT (4)",IF(R34>=50,"PASS (5)",IF(R34>=40,"PASS (6)", "REFERRAL")))))). The idea is the AVERAGE function calculates the average of the specified cells, and the IF function checks the value in cell R5(which is the Overall Performance column) and returns the corresponding text label, within the same cell. is this calculation possible??
@@MDataFinnovatics Hi, found another way around it. here is how: =IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=84.5,"Distinction (1)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=75.5,"Distinction (2)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=67.5,"Credit (3)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=59.5,"Credit (4)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=49.5,"Pass (5)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=39.5,"Pass (6)","Referral (7)"))))))
Amit, you have to show the data in Excel only then we can help you. Anyways you can use COUNTIF formula if you want to check whether the student is absent in any of the exam or in a particular exam.
@@MDataFinnovatics suppose a student (out of 6 subject) had appeared in 5 subject and absent in 1 subject,and that point we write ABS for that particular subject then how can we count total of all 6 subject ,it is giving error becoz we have write ABS in place of number.
@Amit, No need to use ABS formula as ABS formula converts the negative numbers to positive. Through COUNTIF formula you can check how many times that particular student is appearing. If the formula gives you 5 it means he was absent in 1 exam, if it gives 4 it means he was absent in 2 exams because there are total 6 subjects in total which I am assuming.
Call us at +91-9354674901 for
Advanced Excel LIVE Training,
Excel Automation, Excel Dashboards, and Power BI assistance. 😀😀👍
Hi
I want logical function class please
Hi
Dashboard and power BI
This is really good,
In every view every one discuss only one formula but u clear my concept with the multiple formula in
Thank you so much, I appreciate
very good sir
sir aapka shikhane ka tarika bahot achha he, bahot bariki se sikhate he,
thank you sir
Thank you Raj Patel for your positive feedback!
Very interesting. Thanks for guidance
Santosh - your welcome and thanks for liking the videos. 👍
KAI HOURS KI SEARCHING KE BAAD AAPKI VIDEO SE SOLUTION MILA. THANKS
Learning Tube, Thank you for your positive comments.
Sir thank you very much. you can solve my big problem with this video.Thank You.
Your welcome Ayaz Laliwala. Share and subscribe Mdata Finnovatics channel for more amazing and knowledgeable videos!!
Thanks for this video
Very useful..❤
Your welcome Vijay!!
great way to make understand is the best part of video thanks.
Thank you Live Love!
Very nice video.. clarify most of the doubts. thanks you
Thanks. Please share the video with your friends and subscribe the channel for more interesting videos.
Sir aapke sabhi video SUPER h
Thanks, saurabh!
You are really great. Thank you very much.
Very good information and well explained. Thank you!
Thank you Charan Salve. Don't forget to share and subscribe the channel!!
R u very good teacher
Thank you!
Excellent 👍
Sir, attandance sheet me Saturday "A" hone per Sunday bhi "Leave" count ho jaye aur Monday "A" hone per Sunday bhi "Leave" count ho jaye aur Saturday or Monday "A" hone par 3 din Leave count ho jaye aesa formula bataiye.
You can use *"Nested if"* , *"OR"* formula together based on the scenario.
Very clear funda
Thank you!
Thank you so much sir
nice. please always put the file in each excel video
Thanks. The link is given in the video description from where you can download the excel files. You can get all the files from this Link - www.mdatafinnovatics.com/youtubevideoattachments/.
very helpful
Best examples with multiple formula
Thank you for your appreciation!
Thank you bhaiya
very nice learning
Nasemuddin, Thank you! 😃
Outstanding sir
Really great sir thaka a lot
Thank you, Desi Recipes!
Sir I want learn from beginning Excel by online only Friday class
Imran, please visit the below link for the training
mdatafinnovatics.com/live-advanced-excel-training/
Excellent Sir👍👌
Thank you Swade alhade cooking!
Very nice.
Excellent sir ji
Thanks and welcome
Well explained
Thank you, Premjith KM
Very nice way of explaining 👍
Thank you so much 🙂. Please like the video and share with your friends.
it was great i love it
The formula for 4th question, if we want to add the same complete formula with one more criteria, How to add, l mean, bracket close then we add or comma will work.
This is solid Video
like it. 👍
Thanks Debclavtech!!
Good.
Sir nested if functions me logical test me sab numbers use karte hai samzane ke liye, but uske jagah words use kaise karte hai??
Words can be used in the same manner as numbers. I'll try to make a video about this reasoning.
Sir u are doing a great job 👍...gonna contact you soon
Thank you Sir!!
Could you please share the practice file?
Very Good Vdo
Thank you Waseemraja!
Sir agar hum chart banate he row me company name and column me item ke rate
Aur agar hame ye dusare sheet me ye result chahiye ki is company ko ye item diya he to uska rate vaha ana chahiye
To kaise kare sir
how to Calculate the PR to PO duration based on the followings:
If LOA date is available ignore the PO date and calculate the Cycle time from LOA date less RFQ Date (if RFQ date is missing consider the PR Approval Date)
Waiting your reply.
Sir, we have solved your query and reverted you back on the email.
Fabulous bro
Thanks Arsh Acadmy!
Content ❤
I am from Faridabad
Your welcome Tarun!
Weldon bro owesome
Thank you Rohit Kumar!
Good 👍
Thanks Vijay!
fantastic
Thank you Brajasundar!!
Write 'eli for gift, in front of females having salary less then 50000, if not Write 'not eligible for gift'
Are u cmplt assignment mam plz reply
Only give two double cots
@@mayurpardhi261 No
Can u help me
great sir g
Thanks..!
If I have some values in one column 0.0, 0.81, 1.25, 2.50, 3.50 but we want print to other column 0 to 0.5 through if condition so plz suggest formula sir ji or any guys
Studypoint, I am not getting your condition. Aap detail me apni condition ko bataiye ya fir agar aapke pass koi excel file hai jisme ye condition hai to usko aap email kar sakte ho support@mdatafinnovatics.com par with complete detail. We will solve and revert you back. Thank You!!
Excellent
Thanks 🙂
Sir, How I can delete all special characters from my excel in a single excel formula. pls, help.....
Hi Surbir. Please refer this video - ua-cam.com/video/4POO7Y1GlIw/v-deo.html
How to use nested if with and function
You will get a video on this topic very soon!
This is the video on Nested IF with AND function. ua-cam.com/video/Ng3rcSKWV4E/v-deo.html
How can we calculate commission with given weightage
Sir can we apply multiple if on this question along with "and" and "or"
I have to calculate price of different vehicles based on used and new
Sir ,
01) In-patient = private hospital = form D
02) In-patient = recognized hospital = form B
03) Out-patient = recognized hospital = form D
ye tino conditions if formula mein kaise dall sakte hai . Pls guide
Rakesh, you need to use IF & AND formula together to solve your query!
If need more clarity on the formula, please share your excel file with detailed query on support@mdatafinnovatics.com
I have one problems. I create my excel file in which Total are different and when I wanna grade of it that time face problems
Hi Upendra, Please share your problem at support@mdatafinnovatics.com with your excel file.
Sir Stock Buy karne par add ho jaye sell karne par minus ho jaye uske liye kya formula rahega
You can use the IF condition on Buy and Sell. With Buy you can add and with Sell you can substract the values.
@@MDataFinnovaticsSir, please share formula
You have to share the data first in Excel, then we can help you with the formula.
Sir me ne if or and 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 ?
Hallo, im working on an excel sheet that has a column named Overall results. Under this column I have used average function to find the average of each students score(=AVERAGE(F5,J5,K5,L5,O5,P5,Q5) ). My desired outcome is to display conditions "Pass" "Fail" "Refer" on the same column of the Overall performance. I have tried this formular =AVERAGE(F5,J5,K5,L5,O5,P5,Q5) + IF(R34>=85,"DISTINCTION(1)",IF(R34>=76,"DISTINCTION(2)",IF(R34>=68,"CREDIT (3)",IF(R34>=60,"CREDIT (4)",IF(R34>=50,"PASS (5)",IF(R34>=40,"PASS (6)", "REFERRAL")))))).
The idea is the AVERAGE function calculates the average of the specified cells, and the IF function checks the value in cell R5(which is the Overall Performance column) and returns the corresponding text label, within the same cell.
is this calculation possible??
Komplit Random, please try to replace the R34 cell with the Average formula.
@@MDataFinnovatics Hi, found another way around it. here is how: =IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=84.5,"Distinction (1)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=75.5,"Distinction (2)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=67.5,"Credit (3)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=59.5,"Credit (4)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=49.5,"Pass (5)",IF(AVERAGE(F5,J5,K5,L5,O5,P5,Q5)>=39.5,"Pass (6)","Referral (7)"))))))
You got the solution. That is amazing!
Fourmula to achcha hain but isko or easy kar do to jada achcha ho
Sure Suyash. We will try to make the formulas more simpler!
We have need some help in excel formula through mail..please tell me would paid money or not.
And also said How many paid
How to use if function when any student is absent in all exam or particular subject.
Amit, you have to show the data in Excel only then we can help you. Anyways you can use COUNTIF formula if you want to check whether the student is absent in any of the exam or in a particular exam.
@@MDataFinnovatics suppose a student (out of 6 subject) had appeared in 5 subject and absent in 1 subject,and that point we write ABS for that particular subject then how can we count total of all 6 subject ,it is giving error becoz we have write ABS in place of number.
@Amit, No need to use ABS formula as ABS formula converts the negative numbers to positive. Through COUNTIF formula you can check how many times that particular student is appearing. If the formula gives you 5 it means he was absent in 1 exam, if it gives 4 it means he was absent in 2 exams because there are total 6 subjects in total which I am assuming.
@@MDataFinnovatics i meant absent for ABS not formula.
anyway how can i share my excel sheet in which i have particular doubt.
You can email us at support@mdatafinnovatics.com with complete query.
And ka 20 example , or ka 20 example, and ka 20 example dejia na please , please, please sir.
Very soon, I will create a video with more complex conditions.
👍
tIs there anyone here to help me complete my assignment?
One excel file sent on your mail
We have shared the file with you over email. Please check