如何使Google工作表公式仅计算一次? [英] How to make google sheet formula just calculate once?

问题描述

我的Google表格中有3行，即库存，价格和总计.因此，我只对股票和价格使用多个"公式，然后将值放入总行中.但是我不希望总行在更改库存值时得到更新或更改值.

I have 3 rows in my Google sheet, that is stock, price, and total. so, I just use "multiple" formula for stock and price then put the value into the total row. but I don't want total row get an update or change the value whenever I change stock value.

有人可以帮助我吗?

推荐答案

Google表格无法以这种方式运行.最简单，最快的解决方案是计算所需的内容，然后使用 CTRL + C 并使用 CTRL + SHIFT进行重新粘贴 + V

Google Sheets is not build to operate in such a manner. The most simple and fastest solution is to calculate what you need and then use CTRL + C and repaste with CTRL + SHIFT + V

这篇关于如何使Google工作表公式仅计算一次?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！