Reference array constant values in a formula

N

notso

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
 
M

Mike H

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

Mike
 
N

notso

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel In Excel how can I block the contenent of a cell? 0
Scrabble Value calculation for Welsh words 0
Skip Reference Sequences during copy 3
Array Constant: How do I reference each value in a formula 3
Array Constant 3
Referencing a cell even if its contents are moved moved/replaced 6
Find a value in table 2
making sure a cell in an array is not duplicated 2

Top