ContributionsMost RecentMost LikesSolutionsRe: Combining FormulasIt breaks on the comma. I can put in a support case if you want me too.Re: Combining FormulasUnderstood. It highlights the whole formula after the comma in the first formula (at the end of the formula). Sorry the screenshot didn't workRe: Combining FormulasHello Evan, Yes I still get an error message for a formula syntax error. (there are extra characters beyond the end of the formula) Re: Combining FormulasAny additional help would be appreciated. Thanks,Re: Combining FormulasNow it is saying there are extra characters beyond the end of the formula.Re: Combining FormulasI am getting a syntax error. I'm not able to find the problem. Any help would be appreciated, thanks.Combining FormulasHello, I posted a question and got this answer: ([Payment Amount]-[Client Fee Due]-Nz([Override Due]))/2 This was VERY helpful; however, I would like to also do an override on certain sales groups. Here is what I suggest but there is an error. If([Marketing Rep],= "SALES REP A", [Payment Amount]*.07) or ([Payment Amount]-[Client Fee Due]-Nz([Override Due]))/2 Thanks for your help!Re: SUBTRACT MULTIPLE FIELDSAwesome... that worked! Thank you!SUBTRACT MULTIPLE FIELDSHello I am trying to subtract multiple fields. Here is what I am trying to do: ((payment amount) - (client fee) - (override) )/2 The main problem I am having is the override field has blanks so it does't recognize the formula. Perhaps the field types need to be changed? Payment amount - Currency Field Client Fee - Currency Field Override - Formula - Numeric Thanks for your help.