2023SU-XA4-IFnLOOKUP

xlsx

School

California State University, Northridge *

*We aren’t endorsed by this school

Course

312

Subject

Finance

Date

Apr 3, 2024

Type

xlsx

Pages

12

Uploaded by LieutenantSnow6770

Report
**==>> PLZ do NOT move any cell, and do NOT insert any row/column! Would -1 for each of the violations to this rule. Without the corrrect file name and w/o saving it onto your PC, -2 peanalty would be im 1. Avalability of items in stock compared to quantity wanted. Compare the quantity desired for a the latter (num of units in stock) is to be found thru a VLOOKUP. === "LADW 2. LACHD: This time you will report the different $amout (not the provider name) 3. Grocery expensive/cheap item lookup. An IF, whose value relies on lookup. The formula is on (Alert/remi # points: 1/2/3: 5/3/4 points 0. *** Save this spreadsheet onto your PC BEFORE any work is attempted , adding your Lname
mposed. an item with the number of units in stock; WP"-type of question, i.e., "lokkup by nature, depends on IF" nlyu for one cell and thus does not need to be copied. inder: Q1 and Q2 formulas need to be copied to other cells) e at the beginning of the filename. Then open the saved copy and work on it.
EduHelp Store Item Name ELMO Board IPEVO Doc Cam MooreCo Glass Board iPad Pro 1 Item wanted: (enter the item name on the right) 2 Quantity desired (enter # items wanted on right) 3 Availability (display "Availale" or "Unavailable") 4 Total price if available: (Calculation of $total) 1 and 2 are data entry, 3 and 4 are formulas Hint: The logic is similar to that of the "seats and enro
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
U Prince $ 45.00 $ 60.68 $ 303.23 $ 749.00 iPad Pro 4 Available $ 2,996.00 TWO formulas above - C10 and C11. (No copy needed - the lookup stays in one given cell) olled students " in Demo 4.
Lname: Fname: Quantity 11 6 3 7 <== Item name entry <== Quantity entry <== A formula to determine availability of an item, thru comarison of quantity OF THAT ITE <== A formula to determine total price of the item you want for the quant you want
EM wanted and quantity in stock
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
(1) 1 Bay View Rehab. Center $686,078.00 2 Children's Bureau of Southern Bay $5,197,762.00 3 Children's Paradise Inc. $3,121,157.00 4 Foothill Family Counseling $3,861,414.00 5 Hamburger Family Center $3,353,699.00 6 Homes for Life Service $100,000.00 7 Intercommunity Child Center $1,609,745.00 8 Los Angeles Unified School District $1,877,623.00 9 Olive Hilltop Treatment Centers, Inc $130,861.00 10 Pacific Asian Psychiatric Services $853,400.00 11 ProviCare Comm. Serv. $915,785.00 12 San Fernando Children's Center $587,063.00 13 SHIELDS for Women Project, Inc. $3,734,250.00 14 South Central Rehab Program $616,644.00 15 Star View Adult Day Care Center $4,396,804.00 16 The Boys and Girls Support Society $6,358,914.00 i ii iii iv Ser No Care Provider Data Summed from Itemized Sheets the nature of the problem is a comparison (IF); but the comparison needs a lookup
Imagine the right side as "on a different page": $3,121,175.00 $10,000.00 $1,876,623.00 $130,816.00 *** "Corresponding 2" means: that is by the same company (in column B) If (1) is not equal to corresponding (2) , list the value ["value"! NOT "company"!] of corresponding (2) here (Else leave it blank) -- so the values in column D are in orders cooresponding to column B; i.e., they are value ofthe companies in Column B but not Column F For each number in (1) (column C), there is a number in (2) (column G) which has the number in (1) (column C) (what line i above means) * We're talking about number here, NOT "company name"!
LastName: ==> FisrtName:==> (2) Homes for Life Service $10,000.00 Olive Hilltop Treatment Centers, Inc $130,816.00 San Fernando Children's Center $587,063.00 South Central Rehab Program $616,644.00 Bay View Rehab. Center $686,078.00 Pacific Asian Psychiatric Services $853,400.00 ProviCare Comm. Serv. $915,785.00 Intercommunity Child Center $1,609,745.00 Los Angeles Unified School District $1,876,623.00 Children's Paradise Inc. $3,121,175.00 Hamburger Family Center $3,353,699.00 SHIELDS for Women Project, Inc. $3,734,250.00 Foothill Family Counseling $3,861,414.00 Star View Adult Day Care Center $4,396,804.00 Children's Bureau of Southern Bay $5,197,762.00 The Boys and Girls Support Society $6,358,914.00 Care Provider Data Reported by Provider
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Most/Least Expensive Item Lookup Produce Unit Price Unit Enter produce name for lookup: Apple 1.49 Lb Display if the item is most/least expensive: Banana 0.79 Lb ("$$$" for most expensive; Celery 1.19 Lb "$" for least expensive; Cherry 5.69 Lb "Other" if none of the above) Dill 1.19 Each Eggplant 1.59 Lb Honey Dew 1.49 Lb The rest: ONLY read the following after you s Kiwi 0.69 Each Lemon 0.49 Each Logic: if the item entered in F3 is the Max of t Mellon 1.29 Lb else if the item entered in F3 is the Max of the Orange 1.29 Lb else display "Other". I have already given the logic. What is left is t I admit: this is the "after pandemic water dow Those who like to have challenges PLEASE i
Cherry $$$ spend more than 30 min on the question. the whole list (B4:B14), display "$$$", e whole list (B4:B14), display "$", to "translate" the above logic into Excel formula. wn" of challenges (less than minimal) to students. ignore my hint/help below which is a tremendous "water down" .
(<== product name data entery) (<== formula)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help