Iteration

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