I was wondering how to make something happen. I would like to take a
formula in excel and assign it to a cell. When the user enters a
number it takes that number and applies it to the formula and returns
the number. Here is an example.


(x / 60)=y if user enter 10 then the formula should return .166~

where x is the users input and y is the returned answer.

If you could help me I would appreciate it.

Have user input into cell A1. In cell B1, enter the formula:

=A1/60

HTH,
Elkar

" wrote:

I was wondering how to make something happen. I would like to take a
formula in excel and assign it to a cell. When the user enters a
number it takes that number and applies it to the formula and returns
the number. Here is an example.


(x / 60)=y if user enter 10 then the formula should return .166~

where x is the users input and y is the returned answer.

If you could help me I would appreciate it.

You can not have data input and a formula in the same cell.

Regards
JG

" wrote:

I was wondering how to make something happen. I would like to take a
formula in excel and assign it to a cell. When the user enters a
number it takes that number and applies it to the formula and returns
the number. Here is an example.


(x / 60)=y if user enter 10 then the formula should return .166~

where x is the users input and y is the returned answer.

If you could help me I would appreciate it.