如果错误添加到公式

Kaleb · 07/13/22

你好:

我想将IFERROR添加到下面的公式中，这样当Stories为0时，我就不会得到#DIVIDE Error。=$Stories$11代表总数

= $ 11美元/故事(电子邮件保护)

谢谢

布伦特威尔逊 · 07/14/22

您可能不需要IFERROR，因为它更多地用于捕获错误

试试这个

=如果((电子邮件保护)=0， [Stories]11，[Stories]11 /(电子邮件保护)）

凯利摩尔 · 07/14/22

嘿@Kaleb

= IFERROR(故事11美元/(电子邮件保护)”、“)

如上所述，如果发生错误，末尾的“”将使单元格为空。如果您希望显示其他内容，请在引号之间输入文本，如果您想输入数字，例如0，请输入the值在逗号之后和所有引号的位置。

有一种方法可以将上面的公式转换为列式公式。这将允许公式总是自动添加到任何新行。

创建一个摘要字段(右侧菜单ribbon)，并设置字段= $Stories$11

将上面公式中的$Stories$11替换为您刚刚创建的摘要字段(摘要字段的引用是摘要字段名后面跟着井号)。

凯利

Kaleb · 07/14/22

Hey @Kaleb<\/a> <\/p>

=IFERROR($Stories$11 \/ Stories@row,"")<\/p>

As written above, the "" at the end will make the cell blank if an error occurs. If you wish to display something else, enter text in between the quotes, if you want to enter a number, eg zero, enter the <\/em>value after the comma and in place of all quotes. <\/p>

There is a way to convert your formula above to a column formula. This will allow the formula to always automatically be added to any new row.<\/p>

Create a summary field (right hand menu ribbon) and have the field = $Stories$11<\/p>

replace the $Stories$11 in the formula above with the summary field you just created (the reference for the summary field is Summary field name followed by pound sign). <\/p>

Kelly<\/p>","bodyRaw":"[{\"insert\":\"Hey \"},{\"insert\":{\"mention\":{\"name\":\"Kaleb\",\"userID\":146904}}},{\"insert\":\" \\n=IFERROR($Stories$11 \\\/ Stories@row,\\\"\\\")\\nAs written above, the \\\"\\\" at the end will make the cell blank if an error occurs. If you wish to display something else, enter text in between the quotes, if you want to enter a number, eg zero, enter th\"},{\"attributes\":{\"italic\":true},\"insert\":\"e \"},{\"insert\":\"value after the comma and in place of all quotes. \\nThere is a way to convert your formula above to a column formula. This will allow the formula to always automatically be added to any new row.\\nCreate a summary field (right hand menu ribbon) and have the field = $Stories$11\\nreplace the $Stories$11 in the formula above with the summary field you just created (the reference for the summary field is Summary field name followed by pound sign). \\nKelly\\n\"}]","format":"rich","dateInserted":"2022-07-14T01:34:25+00:00","insertUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2023-06-09T23:28:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/336067#Comment_336067","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/336067#Comment_336067

我错过了引号。知道了，谢谢。

凯利摩尔 · 07/14/22

太棒了!如果您需要关于Summary字段的更多指导，请告诉我们。在公式中使用摘要字段将使公式更加健壮。

凯利

Kaleb · 07/14/22

Hello All:<\/p>

I would like to ad IFERROR to the Below Formula so when the Stories is 0, I do not get a #DIVIDE Error. =$Stories$11 Represent the Total<\/p>

=$Stories$11 \/ Stories@row<\/p>

Thanks<\/p>","bodyRaw":"[{\"insert\":\"Hello All:\\nI would like to ad IFERROR to the Below Formula so when the Stories is 0, I do not get a #DIVIDE Error. =$Stories$11 Represent the Total\\n=$Stories$11 \\\/ Stories@row\\nThanks\\n\"}]","format":"rich","dateInserted":"2022-07-13T22:57:47+00:00","insertUser":{"userID":146904,"name":"Kaleb","url":"https:\/\/community.smartsheet.com\/profile\/Kaleb","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hzlAoSbUIDs!hU_D4f686H8!MeM8OksBL1v","dateLastActive":"2023-06-06T20:54:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/93201\/if-error-add-to-formula","embedType":"quote","name":"IF Error Add to Formula"}"> https://community.smartsheet.com/discussion/93201/if-error-add-to-formula

我的第二行结果是500%。应该是0%

凯利摩尔 · 07/14/22

能不能给我截图。正如Brent指出的那样，IFERROR只有在出现错误时才有效。“False”语句不是错误。

凯利

如果错误添加到公式

答案

帮助文章参考资料欧宝体育app官方888

类别