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