Data Analysis

[Khidir Nassar]

How can I use Data table for analysis if I have more than 2 variables

 

[jim may]

Provide us with a bit MORE of your setup and requirements.

 

[Khidir Nassar]

Provide us with a bit MORE of your setup and requirements.

Dear Sir, Thanks for your kind & prompt reply my data as below

Interest RATE	3%	Variable 1
Number of Payment	30	Variable 2
Amount Borrowed	$237,189.38	Variable 3
Monthly PAYMENT	$1,000.00	If I have 2 variable I setup one on raw & one on column but Now I have 3 I want to know how to set data for analysis

<tbody>
</tbody><colgroup><col><col><col></colgroup>

 

[jim may]

Sorry, I've been out-of-town a few days...

Are you familiar with the Pmt() Function applied here in Cell D3? In cell D3 all 3 variables are called. Any question? Jim

Excel 2010
	A	B	C	D
1
2
3		3.00%		$1,000.00
4
5		30
6
7		237,189.38
Sheet1

Cell Formulas
Range	Formula
D3	=PMT(B3/12,B5*12,-B7)