IS312 IF-n-VLOOKUP.xlsx
Hire our professional essay experts at Gradehunters.net who are available online 24/7 for an essay paper written to a high standard at an affordable cost.
Order a Similar Paper Order a Different Paper
|
Sheet1 |
4 points. |
Look up a student’s semester percentage as well as his/her grade, based on which class she is in. It is a simple lookup; |
|
the only thing added is that we need to know which class the student is in, so as to use the right lookup table. So it is three lookups nested in several Ifs |
||
|
(knowing which lookup table/lookup range to use in the VLOOKUP formula depends on IF judgement). |
||
|
Sheet2 |
5 points. |
Several customers bought several types of vitamins from the VitaminStore. Price-Paid is quantity multipies CORRESPNDING unit-price of an item. |
|
Then a simple total is calculated. After the summation, a discount may be eligible depending on how much the total is. A dicount-rate table is given. |
||
|
Sheet3 |
5 points |
CSUN class lookup. Given the class capacity (total seats) and the #enrolled, write formulas to enable the lookup for seat availability, AND #seats reamaining if available. |
Everyone needs a little help with academic work from time to time. Hire the best essay writing professionals working for us today!
Get a 15% discount for your first order
Order a Similar Paper Order a Different Paper
