SIMPLIFY

This function applies SymPy simplification rules to transform an expression into a simpler algebraic form while preserving equivalence.

Simplification seeks an equivalent expression g(x) for a given f(x) such that:

f(x) = g(x)

while reducing algebraic complexity when possible.

Excel Usage

=SIMPLIFY(expression)
  • expression (str, required): Expression to simplify.

Returns (str): String representation of the simplified expression.

Example 1: Simplify a trigonometric identity

Inputs:

expression
sin(x)2 + cos(x)2

Excel formula:

=SIMPLIFY("sin(x)**2 + cos(x)**2")

Expected output:

"1"

Example 2: Simplify a rational expression

Inputs:

expression
(x**2 - 1)/(x - 1)

Excel formula:

=SIMPLIFY("(x**2 - 1)/(x - 1)")

Expected output:

"x + 1"

Example 3: Simplify logarithmic exponential expression

Inputs:

expression
log(exp(x))

Excel formula:

=SIMPLIFY("log(exp(x))")

Expected output:

"log(exp(x))"

Example 4: Simplify polynomial product and sum form

Inputs:

expression
(x + 1)*(x - 1) - x**2 + 1

Excel formula:

=SIMPLIFY("(x + 1)*(x - 1) - x**2 + 1")

Expected output:

"0"

Python Code

from sympy import sympify
from sympy import simplify as sympy_simplify

def simplify(expression):
    """
    Simplify a symbolic expression.

    See: https://docs.sympy.org/latest/modules/simplify/simplify.html#sympy.simplify.simplify.simplify

    This example function is provided as-is without any representation of accuracy.

    Args:
        expression (str): Expression to simplify.

    Returns:
        str: String representation of the simplified expression.
    """
    try:
        normalized_expression = expression.replace("^", "**")
        expr = sympify(normalized_expression)
        result = sympy_simplify(expr)
        return str(result)
    except Exception as e:
        return f"Error: {str(e)}"

Online Calculator

Expression to simplify.