iwork 数字的条件格式
我正在尝试在 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 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
嗯..这对你不起作用。问题在于，您不能让一个公式将自身作为决定值来成为新公式的一部分。也就是说，它必须是有条件的，并且只能显示公式引用的值。
如果您希望该单元格显示值 350，请将公式的第一部分放入单独的单元格（或表格、工作表等）中。然后，在您想要显示为 350 的单元格中，输入
“应该得到您想要的结果”。
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
Should get you the result you want.'