I am trying to get this formular to do a different formular based on values in a specific column.

Commodore

=IFERROR(IF(CurrencyBuildLocation@row = "CAD", ([Revenue $ CAD]@row - [Total Costs]@row) / [Revenue $ CAD]@row), IF(CurrencyBuildLocation@row = "USD", ([Revenue $USD]@row - [Total Costs]@row) / [Revenue $USD]@row))

Paul Newcome

Try removing the IFERROR as well as the closing parenthesis after the second [Revenue $ CAD]@row.

Paul Newcome

Are you getting an error?

Commodore

The only output i get is this part IF(CurrencyBuildLocation@row = "CAD", ([Revenue $ CAD]@row - [Total Costs]@row) / [Revenue $ CAD]@row).

No output from the second part.

Paul Newcome

Try removing the IFERROR as well as the closing parenthesis after the second [Revenue $ CAD]@row.

Commodore

This solved my problem. Thank you

Paul Newcome

Happy to help. 👍️