Sir I have a few questions; 1) Sir how do we know where in the paper we are required to use the IF, Nested IF or the IFS function? 2) Secondly, sir what is the Sum IF Function? 3) Do you have any guess for IGCSE 0417 P3 taking place on 18th April, 2024?
IF used if you have 1 logocal statement which will result in 1 of 2 answers. Nested IF when you have more than 2 possie answers. You can use IFS instead of Nested IF bit i would not use IFS for the exam as it is not specified in the syllabus.
@@areejfatima-tx8jc SumIFS is the same as SumIF but instead of adding values in a sum column based on 1 criteria it will sum based on multiple criteria. I have not made a tutorial on this yet but will do soon.
That is a totally different function. Lookup will return results based on if something exists in a lookup column, IF functions return a result based on criteria. If this is not clear then please watch my tutorial on Lookup finctions.
i don't keep the files i use for tutorials, sorry. The amount of data on these spreadsheets is very small so you can easily copy the data in your own spread sheet so that you can practice.
TO the point with necessary details, I've recommended this as top 1 to all my friends. I have a question tho, how do i know whether i should use a nested IF function or an IFS function?
First thank you for you comment and for the recomendation. Nested IF or IFS, you don't its your choice. For the Igcse exam however i would use nested IF as that js what you find in the marksheets and if i recall correctly the syllabus states IF function not IF functions which would include IFS as well.
@@paphitisn Ahh that makes sense. Thank you for your response. I haven't been able to find any of your SUM and Average functions videos. Is there a separate video that explains SUMIF and AverageIF? AVERAGEIF did come in one of the pastpapers, and im struggling in differentiating between AverageIf and Average.
@@paphitisn yeah the intro has the SUM function only. If you are going to generate one, please do so before 18th. It will be much appreciated as Ig p3's on that day.
That depends on you. The tricky part on the spreadsheet isn't knowing the formulas, it is understanding which formulas to use to solve the problem after you have understood what is being asked. Practicing past papers will help you understanding how questions are asked and what the requirements are. If you have not solved many past papers leading up to the exam then you can do with the practice. Don't over do it. You need to rest well before an Exam.
@@savagex_2008 the paper with Bobby's Bricks. Yes IF and AND are in the syllabus so you can use them. This is what you would use instead of IFS which is not in the syllabus. IFS essentially replaces the combination of IF(AND(
how do we know when to put logic operators and numbers in speech marks? at 10:48 if you see the function in E4, it has no speech marks so im getting confused
if the criteria is just a number and nothing else then speech marks not needed, If you are using any other character in the criteria (like logic symbols ) then you have to use speech marks. eg B3=3, B3"
SHOCKINGLY BEST ICT TEACHER EVER- (RESPECT, LOVE AND ADMIRATION COMING FROM SAUDI ARABIA)
Thanky for your awesome comment. Respect
THANK YOU SO MUCH YOU SAVED ME 1 DAY BEFORE MY EXAM
Greatest ICT Teacher Ever
You are making me blush :) thanks for your comment. I am glad these tutorials are helping you.
ty tumz is my exam you explained it very well you the best
THANK YOU SO MUCH YOU SAVED ME THE NIGHT BEFORE MY EXAM
Sir I have a few questions;
1) Sir how do we know where in the paper we are required to use the IF, Nested IF or the IFS function?
2) Secondly, sir what is the Sum IF Function?
3) Do you have any guess for IGCSE 0417 P3 taking place on 18th April, 2024?
IF used if you have 1 logocal statement which will result in 1 of 2 answers. Nested IF when you have more than 2 possie answers. You can use IFS instead of Nested IF bit i would not use IFS for the exam as it is not specified in the syllabus.
@@paphitisn And sir what is the Sum IF function?
@@areejfatima-tx8jc SumIFS is the same as SumIF but instead of adding values in a sum column based on 1 criteria it will sum based on multiple criteria. I have not made a tutorial on this yet but will do soon.
This was exciting. You explain simply, well and neatly. Thank you for sharing.
Thank you for your feedback. It is appreciated
youre a legend
Thank you :)
thank sir it helped me before exam my ict boards of fem/march is today
Good luck
cant u use lookup function instead surely it has to be quicker
That is a totally different function. Lookup will return results based on if something exists in a lookup column, IF functions return a result based on criteria. If this is not clear then please watch my tutorial on Lookup finctions.
Hi Mr.paphitis can you link those excel sheets so we can practice as well
i don't keep the files i use for tutorials, sorry. The amount of data on these spreadsheets is very small so you can easily copy the data in your own spread sheet so that you can practice.
TO the point with necessary details, I've recommended this as top 1 to all my friends. I have a question tho, how do i know whether i should use a nested IF function or an IFS function?
First thank you for you comment and for the recomendation. Nested IF or IFS, you don't its your choice. For the Igcse exam however i would use nested IF as that js what you find in the marksheets and if i recall correctly the syllabus states IF function not IF functions which would include IFS as well.
@@paphitisn Ahh that makes sense. Thank you for your response. I haven't been able to find any of your SUM and Average functions videos. Is there a separate video that explains SUMIF and AverageIF? AVERAGEIF did come in one of the pastpapers, and im struggling in differentiating between AverageIf and Average.
I have not generated one yet but will do soon. I think i have something in a past paper and in the intro of excel. I will check and let you know.
@@paphitisn yeah the intro has the SUM function only. If you are going to generate one, please do so before 18th. It will be much appreciated as Ig p3's on that day.
the best teacher
thank you. I am glad this helped you
Sir we could have used lookup in the question instead of the nested IF function if am right
Yes you can. This tutorial was to demonstrate IF and Nested IF.
really helpful, very well explained and very quick learnt it too!!!!!!!!!
that's great news. i am glad this helped you. Thanks for your comment.
Really Helpful but ineed to know that if we have watched all your videos do we attempt some papers
if we have an exam tomorrow
That depends on you. The tricky part on the spreadsheet isn't knowing the formulas, it is understanding which formulas to use to solve the problem after you have understood what is being asked. Practicing past papers will help you understanding how questions are asked and what the requirements are. If you have not solved many past papers leading up to the exam then you can do with the practice. Don't over do it. You need to rest well before an Exam.
very helpful video thank you
Sir the IFS function and XLookup functions are optional right?
Right
Has there been a question where only IFS statement could be used and not the IF
No because IFS is not part of the syllabus. You would use Nested IF functions
@@paphitisn and what about using IF(And(
I saw someone use it in Feb march 2018
the paper with Bobby's bricks. Yes, IF and AND are in the syllabus this is what you would use instead of using IFS which is not part of the syllabus
@@savagex_2008 the paper with Bobby's Bricks. Yes IF and AND are in the syllabus so you can use them. This is what you would use instead of IFS which is not in the syllabus. IFS essentially replaces the combination of IF(AND(
how do we know when to put logic operators and numbers in speech marks? at 10:48 if you see the function in E4, it has no speech marks so im getting confused
if the criteria is just a number and nothing else then speech marks not needed, If you are using any other character in the criteria (like logic symbols ) then you have to use speech marks. eg B3=3, B3"
❤
bald guy ON TOP
teacher do you mind checking your mail please , I have asked you something in there
i loved the video
❤