I posted this question 3rd time. from Management Information System only find fi

Question

I posted this question 3rd time. from Management Information System only find figures in above picture. its in Excel Sheet. just give me the processing how to find above figure with using different functions in Excel.
Thank you...

Paragraph Styles Totally Fit Gym Membership Totally Fit Gym-New Members Client Membership Cost Locker Annual TotalYears Total Due Dowa Balance Month 4 Allen 5 Amold 6 Brill 7 George B Grauer 9 Groves 10 Paul 11 Pinder 12 Wiggins 13 Deluxe Individual Family Deluxe Deluxe Individual Individual Individual Individual Yes Yes No No Yes No No No Yes Totals 15 Down 16 Membership Cost Payment 17 Deluxe 18 Family 19 Individual 20 21 Locker Fee 22 Interest Rate Summary Statistics Number of New Members Lowest Monthly Payment Average Naginthly Payment $500 $250 ramndu1250 5%200geen $75

Explanation / Answer

A. in cell C4 use this formula =vlookup(B4,$A$17:$C$19,2,False)

B. in cell E4 use this formula =if(D4="Yes",C4+$b$21,C4)

in cell G4 use this formula = E4*F4

C. in cell H4 use this formula =vlookup(B4,$A$17:$C$19,3,False)

D. in cell I4 use this formula = G4-H4

in cel J4 use this formula = PMT($B$22/12,F4*12,-I4)

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---