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

AICT 9713, Computing 9691 Problems

AAnsarii

AAnsarii

Messages
1,162
Reaction score
6,306
Points
523
acas shaikh said:
in w_08 the formula i used to calculate Discount code is =if(D27="b",(E26/10)*100,D27="c"(E26/15)*100,0)
but its wrong what formula sud i use AAnsarii
Click to expand...

=IF(D26<>"",IF(D26="a",0,IF(D26="b",10/100*E25,15/100*E25)),"")
three possibilities 4 d discount code. start wid a.
if it's a, qp says 0. anything multiplied by 0 = 0, so no need of multiplication.
if its nt dat, it cn be b or c. if b, 10% of subtotal. of=multiplication, 10% = 10/100. so 10/100*Subtotal.
if its nt either of d above, it must be c, so 15% of subtotal --> 15/100*subtotal.
n if no value is in D26, show empty.
 
F

fille spéciale

Messages
1,055
Reaction score
6,654
Points
523
Arfat Sheikh said:
pls solve the 1 question and lemme know how u did it
Click to expand...
The manager wants you to find out which members should no longer be included in the
membership list.
make a new column in memebership tble & use vlookup in that to lookup the Id from the attendence table then filter only those with error....these r d 1s that r to be deleted
 
acas shaikh

acas shaikh

Messages
724
Reaction score
1,546
Points
153
AAnsarii

AAnsarii

Messages
1,162
Reaction score
6,306
Points
523
AngelicBeauty said:
AAnsarii 1995@10Sept SilentSpectator acas shaikh linkinpark syed1995 Tkp Student of the year nipoonnipoonnip Navid Saqib sir

jazakALlah for all ur help :D :)may Allah bless u wid the best in this world and the hereafter :)​
Click to expand...

acas shaikh said:
AAnsarii 1995@10Sept SilentSpectator linkinpark syed1995 Tkp Student of the year nipoonnipoonnip AngelicBeauty Navid Saqib sir
Yes thanx alott........May Allah reward you all....Ameen
Click to expand...

wa iyyakum :)
aameen, may d same b 4 both of u :)
n may v transcend...4 His Pleasure..
 
afshinsalim

afshinsalim

Messages
116
Reaction score
66
Points
38
Navid Saqib said:
Hi there,

Navid Saqib here , teaching both subjects in Different schools in Lahore from last 19 years.

if you have problem regarding it Post your questions here .......

Navid Saqib
LGS,BDC,KIMS,LLC,SISA

GHA Gulberg,GHA Defence,Nova Quest Gulberg
Click to expand...

hello sir,
i need help with AICT paper 4 o/n12 q3 and 4.
thanx
 
You must log in or register to reply here.
Top