subtraction formula

Mailynm

Hello! I’m trying to use a simple subtraction formula =[# of Transactions]@row - [Total Rejected]@row to populate a total processed column however if total rejected isnt populated then it automatically places the number of transactions into to total processed….i’ve tried multiple things with no luck. Any help you can provide is greatly appreciated!

Kelly Moore

Hi @Mailynm

Would this work for you?

=IF([Total Rejected]@row<>"", [# of Transactions]@row - [Total Rejected]@row)

The IF first checks that the [Total Rejected] is not blank. If there is something in the [Total Rejected] cell, the subtraction happens. Otherwise the [total processed] cell remains blank. If you wish for a different outcome rather than keeping the [total processed] blank, we can build that. Let me know.

cheers

Kelly

Kelly Moore

Hi @Mailynm

Would this work for you?

=IF([Total Rejected]@row<>"", [# of Transactions]@row - [Total Rejected]@row)

The IF first checks that the [Total Rejected] is not blank. If there is something in the [Total Rejected] cell, the subtraction happens. Otherwise the [total processed] cell remains blank. If you wish for a different outcome rather than keeping the [total processed] blank, we can build that. Let me know.

cheers

Kelly

Mailynm

@Kelly Moore This worked perfectly and did exactly what I needed it to do! Thanks for your help!!