MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Sid on February 22, 2001 12:19 AM

I have a cell in which I enter data and anothe rone is computed. I wnat to see the output for multiple values of input. Using scenarios, i have to feed in values one by one...becomes cumbersome wheni have to see 100 scenarios. is there any way i can have a output table showing input and output values depending on the range of inputs and intervals between inputs...thanks

Posted by Mark W. on February 22, 2001 12:26 PM

Yes, take a look at the Excel Help topic for
"data tables".