如何将这个方程式写入Excel( - ((N)/ 2)), - ((N-1)/ 2)), - ((N-2)/ 2)),...,0, ((N-2)/ 2),((N-1)/ 2),((N)/ 2) [英] How would I write this equation into Excel (-((N)/2)), -((N-1)/2)), - ((N-2)/2)),...,0,...,((N-2)/2), ((N-1)/2), ((N)/2))
问题描述
可以使用数组公式。假设您的值 N
在 C4
单元格中。
在一列中选择范围(例如 B1:B20
),然后粘贴以下公式:
=($ C $ 4-(ROW(INDIRECT($ C $ 4&:& 3 * $ C $ 4)) - $ C $ 4))/ 2
并按 CTRL < kbd> + SHIFT + ENTER 进行评估。
如果要将数据存储在行中,请在一行中选择范围(例如 B1:S1
),然后粘贴以下公式:
= TRANSPOSE(($ C $ 4-(ROW(INDIRECT($ C $ 4&:& 3 * $ C $ 4)) - $ C $ 4))/ 2)
并按 CTRL < kbd> + SHIFT + ENTER 进行评估。
I need to input an equation into excel, I have set a cell to equal N and then I need another cell to hold the information (-((N)/2)), -((N-1)/2)), - ((N-2)/2)),...,0,...,((N-2)/2), ((N-1)/2), ((N)/2))
You can use array formula. Suppose, your value N
is in C4
cell.
Select range in one column (for example B1:B20
), then paste following formula:
=($C$4-(ROW(INDIRECT($C$4 & ":" & 3* $C$4))-$C$4))/2
and press CTRL+SHIFT+ENTER to evaluate it.
If you'd like to store data in row, then select range in one row (for example B1:S1
), and paste following formula:
=TRANSPOSE(($C$4-(ROW(INDIRECT($C$4 & ":" & 3* $C$4))-$C$4))/2)
and press CTRL+SHIFT+ENTER to evaluate it.
这篇关于如何将这个方程式写入Excel( - ((N)/ 2)), - ((N-1)/ 2)), - ((N-2)/ 2)),...,0, ((N-2)/ 2),((N-1)/ 2),((N)/ 2)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!