| 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 |
| 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 | |||
Threaded Mode
