• 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)

Novemeber 2007 ICT Paper 3

A

AhmadArabiyat

Messages
29
Reaction score
1
Points
13
Hey, I'm having a problem with the excel part of this paper, there is a 'nested IF' in it, which is kinda confusing.

=IF(E7 >=30,G7*RateC,IF(E7 >=20,RateB*G7,IF(E7 >=10,G7*RateA,0))) ---> gives an answer.

=IF(E7 >=10,G7*RateA,IF(E7 >=20,RateB*G7,IF(E7 >=30,G7*RateC,0))) ---> gives a different answer than the one before.

The mark scheme used the first one, It's kinda confusing, how would I know in which order to put them?
 
You must log in or register to reply here.
Top