我需要你帮我写一个公式。

伊莱史密斯

逻辑

如果单元格b >0，则计算单元格b-单元格a的总和

卡森Penticuff

Yes I do get a circular reference. What I want to do if possible is if the month = $0 leave it as $0. but if the month is greater than $0 then take that amount and subtract it from the previous months amount to get the difference.<\/p>","bodyRaw":"[{\"insert\":\"Yes I do get a circular reference. What I want to do if possible is if the month = $0 leave it as $0. but if the month is greater than $0 then take that amount and subtract it from the previous months amount to get the difference.\\n\\n\"}]","format":"rich","dateInserted":"2023-06-12T14:15:49+00:00","insertUser":{"userID":162272,"name":"Elayne Smith","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Elayne%20Smith","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!z_neMx7Hvj4!mVDfnuqtMWQ!RH9Ly5uQ-po","dateLastActive":"2023-06-13T12:50:51+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\/380093#Comment_380093","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/380093#Comment_380093

您需要添加另一列才能进行计算。

ker9

嗨@Elayne史密斯

请试试这个:

=IF([ColA]@row > 0， [ColB]@row - [ColA]@row, 0)

如果ColA <=0，则返回0

(将“ColA”和“ColB”更改为实际列名)

希望这对你有帮助!

伊莱史密斯

它给了我#循环引用

这是我做的公式

=如果((电子邮件保护)> 0,(电子邮件保护)-(电子邮件保护), 0)

如果我将行名放入括号[]，它不会改变

卡森Penticuff

你要把公式放到五月或四月那一行吗?

伊莱史密斯

进入五月行

雷林德斯特伦

@Elayne史密斯，

你要把这个公式粘贴到哪一列?听起来你是在单元格b中执行这个公式如果你得到一个循环引用。这个公式不适用于单元格/列b，因为它是计算和写入的单元格。

伊莱史密斯

是的，我确实得到了一个循环参考。如果可能的话，我想做的是，如果月份= 0，保持它为0。但如果这个月的收入大于0美元，那么就用这个数字减去前一个月的收入，得到差额。

卡森Penticuff

Yes I do get a circular reference. What I want to do if possible is if the month = $0 leave it as $0. but if the month is greater than $0 then take that amount and subtract it from the previous months amount to get the difference.<\/p>","bodyRaw":"[{\"insert\":\"Yes I do get a circular reference. What I want to do if possible is if the month = $0 leave it as $0. but if the month is greater than $0 then take that amount and subtract it from the previous months amount to get the difference.\\n\\n\"}]","format":"rich","dateInserted":"2023-06-12T14:15:49+00:00","insertUser":{"userID":162272,"name":"Elayne Smith","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Elayne%20Smith","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!z_neMx7Hvj4!mVDfnuqtMWQ!RH9Ly5uQ-po","dateLastActive":"2023-06-13T12:50:51+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\/380093#Comment_380093","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/380093#Comment_380093

您需要添加另一列才能进行计算。

伊莱史密斯

好的，谢谢!

雷林德斯特伦

我相信，一旦从May(单元格b)列引用了另一列，就会返回循环引用错误。