• We need your support!

    We are currently struggling to cover the operational costs of Xtremepapers, as a result we might have to shut this website down. Please donate if we have helped you and help make a difference in other students' lives!
    Click here to Donate Now (View Announcement)

Iɴғᴏʀᴍᴀᴛɪᴏɴ ᴀɴᴅ Cᴏᴍᴍᴜɴɪᴄᴀᴛɪᴏɴ Tᴇᴄʜɴᴏʟᴏɢʏ (0417) : Pᴏsᴛ ʏᴏᴜʀ ᴅᴏᴜʙᴛs ʜᴇʀᴇ! ᴴᴰ

Was this helpful


  • Total voters
    113
Messages
36
Reaction score
125
Points
43
May june 2011 paper 31 wat s the IF formula ???
the one in mark schem edoesnt work for me :(
AND
IDONT GET THIS

http://papers.xtremepapers.com/CIE/Cambridge IGCSE/Information and Communication Technology (0417)/0417_s11_qp_31.pdf

"In cell O8 use a formula to display the word Yes if the athlete’s longest throw breaks the Olympic record or display the word No if it does not. (Remember that there are two records, one for men and one for women.) "

http://papers.xtremepapers.com/CIE/Cambridge IGCSE/Information and Communication Technology (0417)/0417_s11_ms_31.pdf

=IF(D8="Male",IF(K8>$D$3,"Yes","No"),IF(K8>$D$4,"Yes","No"))

So that forumula is saying:
If D8 has the word male, and if K8 is bigger than D3, type yes. If lower type no.
If D8 does NOT have the word male (aka a simpler way of writing instead of female), and if K8 is bigger than D4, type yes. If lower type no.


=IF(D8="Male",IF(K8>$D$3,"Yes","No"),IF(K8>$D$4,"Yes","No"))
Green is "IF TRUE", red is "IF False"

Furthermore:

IF(K8>$D$3,"Yes","No")
IF(K8>$D$4,"Yes","No")
Green is "IF TRUE", red is "IF False"
 
Top