Reference array constant values in a formula
 

I have an array constant {1000,1.5,2%} in cell A1.
The first value is S, the second value is P, the third value is R.

How do I write the following formulas one in B1 and one in cell B2.
B3 has the value 400 already in it.

Cell B1 has the formula =(S/P)-(S/P)*R
Cell B2 has the formula =R*B3

Reference array constant values in a formula
 

Why don't you check the answers you were given yesterday when you asked this
same question in 'New Users'?

Mike

"notso" wrote:

I have an array constant {1000,1.5,2%} in cell A1.
The first value is S, the second value is P, the third value is R.

How do I write the following formulas one in B1 and one in cell B2.
B3 has the value 400 already in it.

Cell B1 has the formula =(S/P)-(S/P)*R
Cell B2 has the formula =R*B3

Reference array constant values in a formula
 

Thank you! I couldn't find my question. I thought it didn't get sent, so I
sent it again. Will check the New Users area! .... sorry.

"Mike H" wrote:

Why don't you check the answers you were given yesterday when you asked this
same question in 'New Users'?

Mike

"notso" wrote:

I have an array constant {1000,1.5,2%} in cell A1.
The first value is S, the second value is P, the third value is R.

How do I write the following formulas one in B1 and one in cell B2.
B3 has the value 400 already in it.

Cell B1 has the formula =(S/P)-(S/P)*R
Cell B2 has the formula =R*B3