Share via

long math formulas in Excel

Anonymous
2017-04-13T17:10:08+00:00

I can't get Excel to correct this formula. I need the proper syntax for multiple functions (not IF formulas) within one Excel formula. The correct mathematical answer, which I can get by breaking up the operations, which is a time-waster, is 65,882.35.  How do you do multiple functions (addition, subtraction, multiplication, division) in long formulas without confusing Excel?  Am I missing a parenthesis or something?  Why doesn't it show me the correct solution?  It just tells me there's a problem with the formula and how to format it into text.  Here's the formula:

=sum(60,000+(65,000-58,000)/(.97*1.23))

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2017-04-13T17:21:06+00:00

    Do not use the thousand separator 60,000 => 60000. The thousand separator is a display format while the decimal separator is a meaningful indicator.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-04-13T17:26:25+00:00

    Thank you for your prompt and helpful answer.  I suspected it was something simple, but I needed it pointed out to me.

    0 comments