Thanks Andrew. This is great!

I need help with this formula. It's working for HST, but I want to add GST.

Currently it says,

IF(TRIM({Acct})="2145",{Amt} ,0)

How do I change that to say, if the account is 2145 or 2140 show the amount?

I tried this but it didn’t work:

OR(
IF(TRIM({Acct})="2145",{Amt} ,0),
IF(TRIM({Acct})="2140",{Amt} ,0)
)

Anyone?
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario