iwork 数字的条件格式

发布于 2024-09-17 05:37:33 字数 247 浏览 12 评论 0原文

我正在尝试在 iWork 09 Numbers 中创建电子表格。我在单元格中包含值和日期,但是在该日期过去之前,我不希望将相应的值包含在将所有值加在一起的最终“总计”公式中。

下面是其中一个单元格的公式,这工作正常,但它显示单元格值为零,我希望它将其设置为零但显示 350。这样它仍然可以正确计算总数,但始终将 350 显示为价值。

=IF(A7<=TODAY(),350,0) =VALUE("350")

I am trying to create a spreadsheet in iWork 09 Numbers. I have values in cells along with dates, however until this date is passed I don't want the corresponding value to be included in the final "total" formula which adds all the values together.

Below is the formula for one of the cells, this works fine but it shows the cell value as zero, I want it to set it as zero but show 350. So that it still calculates the total correctly, but by always showing 350 as the value.

=IF(A7<=TODAY(),350,0) =VALUE("350")

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

梦醒灬来后我 2024-09-24 05:37:33

嗯..这对你不起作用。问题在于,您不能让一个公式将自身作为决定值来成为新公式的一部分。也就是说,它必须是有条件的,并且只能显示公式引用的值。

如果您希望该单元格显示值 350,请将公式的第一部分放入单独的单元格(或表格、工作表等)中。然后,在您想要显示为 350 的单元格中,输入

=IF('Cell that works out if A7<=TODAY(), 350, "Error")

“应该得到您想要的结果”。

Hmmm.. This is not going to work for you. The problem is that you cant have a formula that refers to itself as the determining value to become part of the new formula. That is, it has to be conditional, and it can only display the value to which the formula refers.

If you want that cell to show the value 350, then put the first part of the formula into a separate cell (or table, sheet, whatever). Then, in the cell you want to display as 350, put

=IF('Cell that works out if A7<=TODAY(), 350, "Error")

Should get you the result you want.'

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文