for B9 i used =IF(OR(TEXT(A9,"dddd")="Saturday",TEXT(A9,"dddd")="Sunday"),A9+1,A9) and it works for me but idk if the examiner will give marks for this method or not
This works, but the question continues to say if it's not closed on any day,the date displayed should be the same as the planned depart date;when I used this it adds 1,even when the port is open everyday
Hello, I hope this message finds you well. I would greatly appreciate it if you could share the file of the paper you solved with us. Your assistance would be invaluable to us, and I thank you in advance for your support. Best regards, Angel
The only possible way to change the date format in the header is by changing the date format on your device. But for me, I can't change the date format on my device so I'll just leave it as it is (some computers can change their date formats and the excel date format automatically changes depending on which device you use. Even if you save it)
@@Allyamjad what I realised is that whenever there is a many to many relationship we use a link table in case your confused on that part, there's a video with the same class example search it up
in cell B9 i wrote: =IFERROR(IF(VLOOKUP(C9,j22port.csv!$A$3:$C$12,3,0)=TEXT(A9,"dddd"),A9+1,A9),A9) it still does what it's supposed to, is it still wrong?
hardest paper ever
Fax
I COULDNT EVEN UNDERSTAND THE FORMULAS MATE
I'm so happy you made this video. Thank you for doing a good Job ❤️
That was HARD..
March 2022 paper, it's damn hard
th-cam.com/video/qbbtoFxOuFE/w-d-xo.html
for B9 i used =IF(OR(TEXT(A9,"dddd")="Saturday",TEXT(A9,"dddd")="Sunday"),A9+1,A9) and it works for me but idk if the examiner will give marks for this method or not
This works, but the question continues to say if it's not closed on any day,the date displayed should be the same as the planned depart date;when I used this it adds 1,even when the port is open everyday
Thank you for the video, may you please post more before Monday 3 October 2022
Hello,
I hope this message finds you well. I would greatly appreciate it if you could share the file of the paper you solved with us. Your assistance would be invaluable to us, and I thank you in advance for your support.
Best regards,
Angel
Hello Mam, How did you change the date format for the header?
The only possible way to change the date format in the header is by changing the date format on your device. But for me, I can't change the date format on my device so I'll just leave it as it is (some computers can change their date formats and the excel date format automatically changes depending on which device you use. Even if you save it)
Hi miss, March 2022 please please please, would be a life saver.
Yep could really use that ngl. Exam be on Thursday lol
@@Allyamjad what I realised is that whenever there is a many to many relationship we use a link table in case your confused on that part, there's a video with the same class example search it up
th-cam.com/video/qbbtoFxOuFE/w-d-xo.html
this is really helpful, thank you.
thanks alot sir !
Where can i get the source files for that paper plzzz
can i get the answer for 2022 May/June- Spreadsheet question
????
chrome-extension://efaidnbmnnnibpcajpcglclefindmkaj/papers.gceguide.com/A%20Levels/Information%20Technology%20(9626)/2022/9626_s22_ms_2.pdf
mark scheme?
@@bluejay8411 yes
that paper was my examination paper lol
How did you do?
@@thestarseeking i survived that test, i got a B
@@moisesitolife_17 Nice. How much did you think you got wrong though?
Thank u so much
Brilliant paper.
Hello..where do you get the source files it would be really helpful
papers.gceguide.com/A%20Levels/Information%20Technology%20(9626)/
Paper 4
th-cam.com/video/ueOq7d0JkU4/w-d-xo.html
in cell B9 i wrote: =IFERROR(IF(VLOOKUP(C9,j22port.csv!$A$3:$C$12,3,0)=TEXT(A9,"dddd"),A9+1,A9),A9)
it still does what it's supposed to, is it still wrong?
Hey