what excel formula could i use to "place the corresponding loan payments in the
march inventory worksheet. (hint:llease use LOOKUP function or IF function)
Formulas Data Review Home Insert Draw Page Layout n Connections Properties Get External Refresh Data All Edit Links mm W 21 22 FIL Stocks Geogra.. | Sort 38 E C D Spring Garden Customer Loans Loan Periods Interest Rates Divisions Copier Printer Fax Loan Amounts $3,000.00 $2,000.00 $1,200.00 5 3 5.0% 6.0% 7.0% Monthly Los Prements (56.61) (60.84) (53.73) 3 + 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 40 41 Loans March Inventory M37 H #of Printers in Inventory Cost oftest $1,000 Total Inventory V 51525 1669 9 10 Ami 11 12 13 14 15 16 17 18 19 20 21 22 720.50 600.42 500.35 170.19 1412 395.34 376.SI 358 58 635 23 Division Model w Product Name 1 Coplar C320 GLS Business Cepler 3 Copier C310 GLS Business Copia 5 Copia CHO GES Business Copiar 10 Fax F350 G Business Fa Fax F300 G Rain Fax 5. Printer P500 5 Baalaa Patta - Printer PSOOL Business Printer- Printer P500 Business Pro. La 1 Fax F600 G Compact Professional Plus Fax 2 Copell C120 GLS Penal Copier Capi C110 $ Tanonal Copler Color CIDO GLS Personal Copier 25 Fax 71000 Personale 10 Capier C220 GLS Personal Plus Copie 15 Copla C210 GLS Personal Plus Cople 12 Copi C200 GLS Personal Plus Code 100 Fax 72500 Personal Plus 5 7200 Pengal Plus 3 Printer 310 Parol Plus Printer: Bubble Ja 3 Printer P101 Pengal Plus Printer-te la 10 Prime PIOG Personal Plus Printer ble det 10 PM PIOS Per Printer. Det Me 10 Primer POOL Personal Printer Der Man 5 Prime PIO Personal Phot Mat 13 Cope CHOOLS Professional Capier 12 Copper C410 CLS Professional Copier 12 Coplier CHOOLS Professional Copie STA F4500 Professionals 3 FAX 7400 Professionale 3 Copia C320 CLS Professional Plus Cape 1 Cepler CSIO GLS Professional Plus Copier O Cepler 500 OLS Professional Plus Copier 5 PAX F5500 Professional Plus For 1 Fax 78000 Professional Plus You Print P10005 Professional Print PostScript 2 Printer PLOOL Professional Printer. La Postarit 2 Printer PICO G Professional Pria Laser PostScript 26 26 R7 28 29 30 31 w Cost 3.55802 2,965.02 2,470.85 1.260,66 1,050.55 1,93228 1,85932 1.770.78 3.136.94 1.191.5 992.98 K27.48 601,96 2,059,03 1.715.86 1.429.89 875.00 720.55 78091 741.73 20032 339.52 121.30 107.93 6,145.25 5,121.54 4,269.62 1.NIS 15 1,512.80 10,62418 8,855,48 7.177.00 2,614.11 2,178.34 3,904.57 1,71864 3,451.56 Vile of Sale Prices B 3,558.02 4,303.32 8,895.05 4,002.77 12,35423 3,335.64 12,606.60 1,701.19 5.252.75 1.418 24 9,761.40 2,635.58 5,577.96 2,510.08 14,166 24 2,390.55 3.136.94 4,234.87 2,18). 15 1.608 63 2,97493 1.940.52 3.309.92 1,117.10 15.199.00 800.25 20,590,34 2,779,70 25,737.90 2,316,41 17,158 1.990 35 87.565.00 1,182.14 3,647.5 984.89 3,90455 1,054.23 118.65 0.004.04 7,021 20 956.33 195.20 458.35 1.233.60 416.54 1.519.95 415.73 73,779,00 8,300,14 $1,482.50 1,01678 31,235,4 5,763.99 9,076 78 2,450.72 7,564.00 2,0422 53,120 BR 14.142.64 NS1.41 11,992.19 9,26.12 13,070.55 3.529.05 2.178.14 2,940.70 3.94.57 5,27112 7,45728 5,02016 6903.12 4,659.61 of Inventory Monthly Loan amat 0.6245 1.55% ZIS 2.1996 0.9196 1.70% 0974 2.46% 0554 0.419 0.52 OS 2609 338 4.47 2.9 1521 0694 06 06 1. ON 0.5 0.27 13405 111.71 41.04 416.95 347.46 199.00 11821 49.24 105.42 10040 47.81 9.17 6.73 31 1.245.02 101752 384.50 367.61 306.14 2,15140 1,7920 1,40103 529.36 44111 790.0 73.02 94 14 15 10.09 1.58% 17 18 19 0 11 2 13 4 95 9.21 1 54 2.27 0.38 0.68% 7 8 13094 Loans March Inventory
