I was hoping I would be able to find what I needed on the internet, but unfortunately I can't seem to word my question generally enough.

I'm looking for a function that is able to take data from a table (i.e. a 1 column table of different numbers), input it, one number at a time, into a formula I have elsewhere, and then take the output of the formula and write it to an adjacent table.

This task seems simple, but I can't seem to find any formulas (or sets of formulas) that will do this for me, and I'd rather keep it in excel then have to program something from scratch.

If this question has already been asked, I apologize in advanced. But I wouldn't know how to search for something this specific.