正确的语法匹配，如果不是，则为空白 [英] Proper syntax Match and If not isblank

问题描述

当Validated Adj = Y时，我需要将Billing工作表中的agt_amt数据替换为BalanceingSheet.Difference与Billing.Agt_Amt的添加中的值.但需要一些有关正确语法的帮助.

I need to replace the data the agt_amt from the Billing worksheet with the value in the Adding of the BalanceSheet.Difference to the Billing.Agt_Amt when the Validated Adj = Y. I have been playing with the Match and if not isblank formula but need some assistance with the proper syntax.

重置问题 我需要检查该值是否已通过验证，因此Validate = Y，然后通过qryDifference.Differernce的值来调整Billing.agt_amt的值.

Restating problem I need to check if the value has been validated hence the Validate=Y, Then Adjust the value of the Billing.agt_amt by the value of the qryDifference.Differernce.

向Craig W询问他的经纪人195.75，他已被确认需要和调整应付给他的金额(-5.50).我需要将原始帐单上的代理商金额调整为190.25.

Say for Craig W his agent amt 195.75 and he has been validated to need and adjustment in the amount due (-5.50) to him. I need to adjust the agent amount to be 190.25 on the original Billing.

因此，我想在Billing工作表上创建一个具有调整后的值和原始值的新列，然后在最终确定工作表之前将该列复制到原始列上.

So I thought to create a new Column on the Billing worksheet with the adjusted value and the original value then copy the column over the original prior to finalizing the worksheet.

 =MATCH([@agtno],qryDifference[agtno],IF(NOT(ISBLANK(qryDifference[Validate Adjustment])),qryDifference[Difference],0))

在其他地方找到解决方案:

Solution found Elsewhere:

=IF([@agtno]=B24,[@[agt_amt]],SUMPRODUCT((Balance!$B$2:$B$7=[@agtno])*(Balance!$F$2:$F$7="Y")*Balance!$E$2:$E$7)+[@[agt_amt]])

推荐答案

不确定内容和使用表格，但是如果您复制/粘贴了公式，则会缺少括号

Not sure about contents and using the table, but if you copied/pasted your formula you have a missing bracket

尝试

=IF(not(ISBLANK(qryDifference[Validate Adjustment])),qryDifference[Difference])

这篇关于正确的语法匹配，如果不是，则为空白的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！