Excel公式含义$

问题描述

这个公式的含义是什么？

  = B9 / $ G $ 3 
  

其实我不明白 $ 的含义。

$这是一个：这意味着如果您复制/粘贴，不要将其视为相对参考。如果你将它复制到下面的单元格中，你会得到

  = B10 / $ G $ 3 
  

ie Excel已经自动更新了B9-> 10的新位置的公式中的行，但是单独使用了G3 - 即它是一个您想要应用于表中所有行或单元格的常量。

what the meaning of this formula?

=B9/$G$3

Actually i didn't understand what the meaning of $ sign.

解决方案

It's an absolute reference: it means don't treat this as a relative reference if you copy / paste. If you copy that into the cell below to it, you'll get

=B10/$G$3

i.e. Excel has automatically updated the row in the formula for the new location of B9->10, but left G3 alone - i.e. it's a constant you've set once that you want to apply to all rows or cells in a table.

这篇关于Excel公式含义$的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！