Variables Referencing Cells Inside Formula

[babeneker]

I am trying to create a calculator where the user just enters a variable percentage value into a cell (in this case, A1 in the example below) and I cannot seem to get variables that reference cells to work with the formulas. Here is an example of what I'm trying to do:

=B3/1.(A1)

Is this possible?

 

[Cubist]

Try:

=B3/(1+A1)

 

[babeneker]

Try:

=B3/(1+A1)

Nope, sorry. I don't want to add the numbers together. I just want the number from cell A1 to fill in as a variable in the formula.

Here's an example of the formula:

1,000,000/1.15 (15, or what is in A1, will fill in after the period)

 

[Cubist]

Divide by 100:

=B3/(1+A1/100)

 

[babeneker]

Divide by 100:

=B3/(1+A1/100)

That worked! Thank you!

 

[Cubist]

You're welcome.

 

[Peter_SSs]

.. or if you did want it to look a bit more like that formula in post 1 with the decimal point written in there, you could do it like this

=B3/("1."&A1)