AS Level IT 9626 March 2023 Paper 2 Spreadsheet

[@ayshea...]

your content is clear but the sound ofthe voice is heard very low could u do improvements on that pls.......

[@jungoo1183]

Hello, for question 8 i got the same answer but my formula was =ROUNDDOWN((B16-(B10*100/B13+B11*100/B14)+10/100*5),0) is it okay?

[@hirusha-adi]

how can you get the correct answer from it? 🤔
this is what it should be:
=ROUNDUP(
(
ROUNDUP((B3*100)/B13, 0)
*ROUNDUP((B4*100)/B14, 0)
)
-
(
ROUNDDOWN((B10*100)/B13, 0)
*ROUNDDOWN((B11*100)/B14, 0)
)
*1.1, 0
)

[@jungoo1183]

@@hirusha-adi what can i say, im a genius

[@rwgldakku1694]

i used right and left function instead of x lookup is it correct?

[@tharinsa5799]

how did u use it?

[@dabyt5214]

@@tharinsa5799 if function

[@GauravMahiya]

I can't use xlookup plz sugguest any other way to answer the question 6

[@finzpapers9364]

Try Lookup function... Same way as lookup...

[@hamdhy7_o]

you may have an old version of Office and cant perform functions like Xlookup and weekday function try to update it or get office

[@swethaashreearumugam5144]

Xlookup is not working for me either, so I used =IF(Sheet1!B8="Landscape",LEFT(B7,FIND("X",B7)-2),RIGHT(B7,LEN(B7)-FIND("X",B7)-1))*1 and its working perfectly fine

[@hamdhy7_o]

@@swethaashreearumugam5144 Bro you need Xlookup

[@reonmel8523]

hello maam, for some reason the source wont let me select the contents from the other worksheet, idk how to work it out

[@timprime5643]

check if ur Excel is in its latest version

[@engr.chnematullah565]

How i get source files ma'am kindly reply me