Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Fiona smiley
 
Posts: n/a
Default Data tables using variables

Hello anyone

I have been trying to work through an Excel Advanced book, for work
purposes. Upon entering data regarding loan estimates the monthly repayment
formulae works ( insert function PMT) but when trying to work just one
variable into the equation by redoing table next to the original with year
variables : Data, tables, column input cell. selecting form original table
then ok. The varied repayments are the same as original
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Tables filtering data Excel GuRu Excel Discussion (Misc queries) 1 November 24th 05 08:41 PM
conditional format of data tables in charts [email protected] Charts and Charting in Excel 2 January 25th 05 03:56 PM
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 05:17 AM
Pivot Tables referring to external data query Excel GuRu Excel Discussion (Misc queries) 4 December 29th 04 06:29 PM
Pivot Tables multiple data fields Excel GuRu Excel Worksheet Functions 2 December 16th 04 12:06 AM


All times are GMT +1. The time now is 10:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"