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
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
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/.
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 ?
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.
Hi brother hope you are well Kindly tell me following:- In one cell contains "5" in which 2 are being decreased and 1 is being included. I want in next cell that 5 shows like"5+--" Pl tell me formula Thanks
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.
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.
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!!
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 , 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
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)"))))))
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
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!
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
great way to make understand is the best part of video thanks.
Thank you Live Love!
Good examples and great Video
Sir aapke sabhi video SUPER h
Thanks, saurabh!
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!!
Very interesting. Thanks for guidance
Santosh - your welcome and thanks for liking the videos. 👍
Bahut acha laga,
Really great sir thaka a lot
Thank you, Desi Recipes!
Outstanding sir
You are really great. Thank you very much.
This is solid Video
like it. 👍
Thanks Debclavtech!!
Very clear funda
Thank you!
very nice learning
Nasemuddin, Thank you! 😃
Well explained
Thank you, Premjith KM
Good 👍
Thanks Vijay!
Weldon bro owesome
Thank you Rohit Kumar!
Excellent sir ji
Thanks and welcome
Fabulous bro
Thanks Arsh Acadmy!
Best examples with multiple formula
Thank you for your appreciation!
Content ❤
R u very good teacher
Thank you!
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.
Thank you so much sir
it was great i love it
Very Good Vdo
Thank you Waseemraja!
Thank you bhaiya
fantastic
Thank you Brajasundar!!
Good.
great sir g
Thanks..!
telephone Bill calculat k liy kon sa formula use ho ga
Could you please share the practice file?
Very good information and well explained. Thank you!
Thank you Charan Salve. Don't forget to share and subscribe the channel!!
I am from Faridabad
Your welcome Tarun!
Tysm sir
Excellent Sir👍👌
Thank you Swade alhade cooking!
Very nice.
KAI HOURS KI SEARCHING KE BAAD AAPKI VIDEO SE SOLUTION MILA. THANKS
Learning Tube, Thank you for your positive comments.
very helpful
how we can color the row by if formula
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. th-cam.com/video/Ng3rcSKWV4E/w-d-xo.html
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... And aur or me jab if ka use karte hai to sirf Yes or No ko validate karne k liye use karte hai kya...??????
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.
Excellent
Thanks 🙂
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
Sir u are doing a great job 👍...gonna contact you soon
Thank you 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/.
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 ?
How can we calculate commission with given weightage
Sir, How I can delete all special characters from my excel in a single excel formula. pls, help.....
Hi Surbir. Please refer this video - th-cam.com/video/4POO7Y1GlIw/w-d-xo.html
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
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.
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
Very nice way of explaining 👍
Thank you so much 🙂. Please like the video and share with your friends.
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/
Hi brother hope you are well
Kindly tell me following:-
In one cell contains "5" in which 2 are being decreased and 1 is being included. I want in next cell that 5 shows like"5+--"
Pl tell me formula
Thanks
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.
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.
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.
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!!
कुछ ज़्यादा ही advance हो गया था !!
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 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.
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.
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!
tIs there anyone here to help me complete my assignment?
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
One excel file sent on your mail
We have shared the file with you over email. Please check
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!
app etna fast explain kerte ho kuch samjh nahi aaya