Philip Treacy
Admin
Forum Posts: 1585
Member Since:
October 5, 2010
October 5, 2010
Offline
Hi Fahad,
The first qs requires you to work out the average score for undergraduates and then look that value up. To work out the average score for undergrads you can use AVERAGEIFS
Then use VLOOKUP to lookup the value using an approximate match.
The 2nd qs just needs you to do exactly as it says. Enter a formula into D2 then copy it down to D10. However I think as it's written in your workbook it is not correct. I think the range I3:J13 needs to be absolute references i.e. $I$3:$J$13.
See attached.
Regards
Phil
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Nneka Amusu, Riny van Eekelen
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 286
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Ruby White
Marisa Bradshaw
Eugene Augustine
MacNaughton Finance
Tanu Rai
Ryan Tyree
Taza Tarwala
Ryan Tyree
Nishi Gurupersad
Tony Johlie
Forum Stats:
Groups: 3
Forums: 24
Topics: 6872
Posts: 30112
Member Stats:
Guest Posters: 49
Members: 33662
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —