K $ 2返回的平均值是多少? [英] What is the mean of K$2 returning?
问题描述
嗨所有我正在Excel工作我有我的excel表中的公式我没有明白是什么是返回K $ 2意味着任何身体帮助我,实际上我是新来的这里我想知道它是什么正在返回意味着我们获得的价值
Hi all i am working on Excel i have formula in my excel sheet i didn't understood what it is it is returning K$2 mean could any body help me please actually i am new to it here i want to know what it is returning means what value we r getting
(IF(ISBLANK(K73),1,K$2)*IF(ISBLANK(L73),1,L$2))
提前感谢
这里我需要乘以我得到的值,我需要减去我会自己的问题,我不明白它是什么重新调整
here i need to multiply the value i get and i need to subtract i will that my self the problem it i don't understood what it is retuning
推荐答案
总是使用 2
- 这是一个常数,所以当你拖动一个公式,其他地址会调整,但$ code > K $ 2 和 L $ 2
始终保持不变。
always using 2
- it's a constant so when you drag a formula down the other addresses will adjust but K$2
and L$2
always remains the same.
K2 = $ K $ 2
和 K $ 2
所以它返回你的 Range(K2 )
或单元格(2,11)
K2 = $K$2
and K$2
so it returns the value that is in your Range("K2")
or Cells(2, 11)
如果您正在评估您的公式可以从里面开始最为嵌套的表达式。
if you are evaluating your formula you can start inside the most nested expression.
(ISBLANK(K73),1,K $ 2)
,如果 K73
为空,则表达式将为 1
,如果 K73
不为空 K2
的值将被返回
(ISBLANK(K73),1,K$2)
, if K73
is blank then expression will be 1
, if K73
is not blank then the value of K2
will be returned
这篇关于K $ 2返回的平均值是多少?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!