| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Constant: How do I reference each value in a formula | New Users to Excel | |||
| Array, Formula, Constant, IF Statement Question???? | Excel Discussion (Misc queries) | |||
| Array Constant? | Excel Discussion (Misc queries) | |||
| Array formula with a constant? | Excel Worksheet Functions | |||
| array formula with constant | Excel Worksheet Functions | |||
Linear Mode
