Thread
:
Array Constant: How do I reference each value in a formula
View Single Post
#
1
Posted to microsoft.public.excel.newusers
notso
external usenet poster
Posts: 24
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)
Reply With Quote
notso
View Public Profile
Find all posts by notso
Array Constant: How do I reference each value in a formula