Excel experts? how do you...?

Answers:3   |   LastUpdateAt:2017-03-15 00:45:56  

Asked at 2012-08-13 02:17:02
hello !
I am using Excel to create a spreadsheet detailing a different loan options.

I have four fields ,
First is the choice: the second is the loan's interest rate : Third is the term, quarter are payments per year :
a fifith be a cell of payments, where the answer will be.

I want to be able to put the name of a particular option in my first field and have to calculate repayments refferring to return to a different worksheet ...
Does this make sense ?
Can anyone help ?

step by step would be appreciated.

thanks ! =)
Answer1determinerAnswered at 2012-08-13 07:10:36
to simplify ..
the question is how I can calculate payments, if the data is in another worksheet ?

When you copy cells, use Edit> Paste Special
. will be given several options on how you want your data to be pasted.

or just when you create a formula.
say depreciation = (interest rate * term) - . payments per year
use mouse clicks.

going to say. if in Sheet1 .. cell E2 (fee )
Press = and then go to another page where the interest rate. then click the cell (it will implement dotted lines).

finish the formula .. and it should be.
Answer2LeighAnswered at 2012-08-22 16:43:03
So in the other spreadsheet has a table like this : MedlinePlus MedlinePlus Option ---------- ----- fee PMT Yr Term MedlinePlus option1 ------- ---- 5 % 30 years - 12 MedlinePlus option2 ---- 4.9% ------ 30 years - 4 MedlinePlus . MedlinePlus . MedlinePlus . MedlinePlus MedlinePlus the name of its range in another worksheet - MedlinePlus call OptionTable MedlinePlus Now , on another worksheet ( in the same tab as the entrance ) . . . MedlinePlus MedlinePlus Create a list of available options : MedlinePlus MedlinePlus option1 MedlinePlus option2 . MedlinePlus . MedlinePlus . MedlinePlus MedlinePlus Then in his cell input option, select Data menu , and then Validation . . . MedlinePlus Select the " List " menu below Allow MedlinePlus Then , in the Source box to place the reference range (unfortunately not a named range ) to the list of choices you made. MedlinePlus MedlinePlus Now , for the rest of your entrance area. . . MedlinePlus Let's say the other worksheet is in : C : mydata Data.xls and Cell option called " option " MedlinePlus MedlinePlus Rate = VLOOKUP ( option [ C : mydata Data.xls ] ! Optiontable , 2 , false ) MedlinePlus Term = VLOOKUP ( option [ C : mydata Data.xls ] ! Optiontable , 3 , false ) MedlinePlus PMT by Yr = VLOOKUP ( option [ C : mydata Data.xls ] ! Optiontable , 4 , false ) MedlinePlus MedlinePlus I'm assuming your rate , term and PMT values ​​OptionTable year are consistent with how you want to use a formula to calculate the payment ( not like the ones that come with Excel ) MedlinePlus MedlinePlus Your result = YourPaymentFormula field (rate, term , PMT per Year)
Answer3mehdi Answered at 2012-11-02 13:57:40
First set up your formulae in the different spread sheet (2) for ALL your options. These formula will all reference the 3 data fields in the primary sheet (1). This you do by building your formula in sheet 2 and when you need to input interest, term or payments you switch to sheet 1 and select the cell with the data and then switch back to sheet 2 and continue with the rest of the formula.
Now when you enter data in the middle 3 fields of sheet 1, ALL options on sheet 2 will calculate an answer. Now all you need to do is have the correct answer appear in field 5 based on field 1 by using "CHOOSE"
Your options are 1 to 4 say (max is 29) and will be entered in A1 say
On sheet 1 start building your formula in field 5
Now you switch to sheet 2 and click the cell with the answer corresponding to option1 followed by the cell with the answer for option 2 etc.
Now if you type 3 in A1 the answer corresponding to option 3 will appear in field 5.
Answer4 Answered at 2017-03-15 00:45:56

prada outlet

Ray Ban Sunglasses Online

moncler outlet

Michael Kors Outlet

Ugg Pas Cher Femme

botas de futbol

Adidas Superstar Sale Online

Doudoune Moncler Pas Cher

The official UGG

uggs for women

Boutique Ugg

toms sale

official NHL jerseys

Canada Goose Womens Coats

longchamp bags on sale

Air Max 90

Air Max Sneakers

Ugg Pas Cher En France

Nike Shoes Discount Marketplace

cheap uggs

Boty Nike Air

pandora outlet store

Adidas Shoes Discount Marketplace

nike shoes

Pandora Store

newest lebron shoes

air force one pas cher

nike sb stefan janoski

Stone Island Outlet

Jordan Store

Doudoune Moncler Site Officiel

nike tn pas cher

nike mercurial soccer cleats

Jordan Schoenen

Moncler Outlet Online

christian louboutin outlet

Yeezy Shoes Discount Marketplace

Ray ban sale online

moncler jacket sale

Kobe Shoes Nike

Hogan Outlet

günstige nike schuhe


nfl store

Adidas Superstar

Nike Air Sneakers

Air max levně

Scarpe Air Max

new pandora charms

Nike Online Store

religion store

Nike Air Max Goedkoop

cheap nike air max

nike joggesko

Pandora Store Sale

chaussures nike pas cher

abercrombie and fitch store

zapatilla adidas

adidas outlet

adidas store

Nike Air Pas Cher

Adidas Originals Superstar

canada goose jackets on sale

Canada goose dam

coach factory outlet online

Ray-Ban Official Discounted Site

Negozi Pandora

Air Max Femme

Nike Factory Store

Pandora Store

Boost Yeezy Sale On Line

nike schuhe günstig

Nike Roshe Run Sale

Original Ugg Boots

Nike Air Jordan 11

new yeezy shoes

chaussure Nike homme

Toms Outlet Online

ugg store

Air max dam

chaussure basket homme

Related Questions
  • Answer This Question:Excel experts? how do you...?