Show amount due in a cell and not a negative number

Question

Show amount due in a cell and not a negative number

Anonymous

I am using excel to create an invoice statement template to calculate service charges

Scenario

If the person has insufficient funds then need to calculate outstanding to be paid.

Eg:

Available credit = $100

Service Charges = $200

Cell calculation = Service charges cell - Available Credit

The invoice amount is shown as -$100 which indicates the person has a credit of $100.

I need the invoice statement template showing as $100 owing

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

Anonymous

Hi Abraham Z,

Thank you for reaching out. My name is Leo, a user just like you. I'd be happy to help you with your concern.

To display the outstanding amount as a positive value, you can use the ABS function (Absolute Value) using this syntax: =ABS(Specific Cell)

Example:

In cell A1: -100 In cell A2 syntax: =ABS(A1)

Then it will display "100" without the negative sign since it returns only the absolute value.

I have tried your example, but it returns 100, I assume that the value given is incorrect. I have switched the values and apply this formula and it works fine.

Available credit = $200 Service Charges = $100 Cell calculation =ABS(Service charges cell - Available Credit)

Result: 100

I hope I provided a helpful solution regarding the issue! Let me know if you have any further questions.

Best Regards,

Leo

0 comments

1 additional answer

Answer 1

Share via

Show amount due in a cell and not a negative number

1 additional answer