Formula Help

jl.furstenberg

Hello,

I am trying to fix a formula that only partially works. Any help would be greatly appreciated.

I have one column, labeled Account# with various drop-down options, multi-select.

I have a second column labeled Multiple Accounts that is a checkbox column indicating when 2 or more accounts have been selected in the Account# column.

In a third column, labeled Allocation, I am trying to use the following formula:

=IF(CONTAINS("1012127330", [Account#]@row), IF(AND([Multiple Accounts]@row = "1"), ([GRAND TOTAL]@row * 0.134), ([GRAND TOTAL]@row)))

Syntax-wise this works; however, I am only getting the GRAND TOTAL at row calculation each time, regardless of whether Multiple accounts is checked or not.

My goal is that when account # "1012127330" is selected AND another account # is also selected, the grand total should be multiplied by 0.134; otherwise, when ONLY the 1012127330 is selected, then the GRAND TOTAL should show.

Paul Newcome

Try this:

=IF(HAS([Account#]@row, "1012127330"), IF(COUNTM([Account#]@row) = 1, [Grand Total]@row, [Grand Total]@row * 0.134))

Paul Newcome

Try this:

=IF(HAS([Account#]@row, "1012127330"), IF(COUNTM([Account#]@row) = 1, [Grand Total]@row, [Grand Total]@row * 0.134))

jl.furstenberg

That did the trick! THANK YOU!!

Paul Newcome

Happy to help. 👍️