Simple iterations

Hi I need some help with getting all the data in a chart for a bunch of iterations so I can make a chart.

The formula is x*(1-x) starting with X= .2 . I need to make each output become the new input for the next calculation.

Looks something like this.

X / Output
0.2 / 0.16
0.16 / 0.1334
0.1334/ ...
and so on all the way to 250 iterations

I kinda figured out how to get what the 250th value would be and can get each next point one by one by pressing f9, but I can't get all the data points together at once by dragging or anything.

Thanks.

Hi I am facing a small issue with DMAX formula. Once i use the formula in the first cell it works fine and in 2nd cell it gives good result but if i have to paste it in the whole column it gives me an error. Attached is the sheet I am trying to work upon. Is there someone who can help me with this? I have a important project pending because of it and your help will be highly appreciated:

Thanks Marvin that's what I was looking for. Glad it was so simple but also mad I couldn't figure it out

Hi SAMEEP

Welcome to the forum
Read the forum rules before the moderators get you...

Forum Rules
2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

If you can Edit/Delete your post, do so, if not you'll need to ask a moderator to help you.

Cheers