IF错误添加到公式中

Kaleb · 07/13/22

你好:

我想ad IFERROR到下面的公式，所以当故事为0时，我不会得到一个#DIVIDE错误。11美元代表总数

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

谢谢

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

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

试试这个

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

凯利摩尔 · 07/14/22

嘿@Kaleb

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

如前所述，如果发生错误，末尾的""将使单元格为空。如果你想显示其他内容，在引号之间输入文本，如果你想输入一个数字，如0，输入the值放在逗号后面并置于所有引号的位置。

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

创建一个摘要字段(右侧菜单带)，并将该字段设置为$Stories$11

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

凯利

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","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2022-10-19T18:53:25+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!BW93jhO9565","dateLastActive":"2022-10-10T14:10:42+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仅在出现错误的情况下有效。“错误”陈述不是错误。

凯利

IF错误添加到公式中

答案

帮助文章资源欧宝体育app官方888

类别