| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Array Constant: How do I reference each value in a formula
I have an array constant {1000,1.2,2%} in cell A1
S = 1000 P = 1.2 R = 2% How do I reference the array constant to create this formula: =(S/P)-((S/P)*R) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| Array formula reference | Excel Discussion (Misc queries) | |||
Threaded Mode
