Macro to Fill with Formula, but Hide Formula to User

I would like to populate the F column with the following formula pulling from the same row in column E, but cant have the formula visible to the user. How can I create a macro to have the corresponding value fill in for the data set? Should I use a loop?

Any help is much appreciated.

Formula:

Please Login or Register  to view this content.

Thank you,

Nick

I would like to fill column F with the resulting value from the following formula:

Formula:

Please Login or Register  to view this content.

The only catch is that the formula cannot be visible from the worksheet.

Thank you for taking a look.

I am new here but i think you don't want the formula to be seen if the cell E2 is blank right? If yes then change your formula to this

Please Login or Register  to view this content.

Norie,

In column F I want the values created by the formula to show. When you click on the cell, I want the value to show up in the function bar, rather than the formula being visible. Any ideas on how to make a macro perform this?