Help with a formula please.

[TheGoat]

Hi guys, I have a formula already but it's not doing exactly what I need it to do, it keeps on replacing values when their not zero. In layman terms this is what I'm trying to do.

I need the Sum of Column A through B to total in column C. Then if Column C equals zero I need it display "Balanced", and if it's greater than or less than zero I need it to display it's value.

I had something that partially worked but on columns that equal zero, but on everything else that didn't it kept on displaying "FALSE"


I'd imagine this is quite easy but I'm pretty new to formulas.

Much appreciated.

Using Excel 2016 btw.

[kersplash]

Can you attach your sample showing the issue.

Go Advanced -> Manage Attachments -> Upload

[alansidman]

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

Use concise, accurate thread titles.
Your post title should describe your problem, not your anticipated solution.
Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

When you have changed the title, please also give full details of the problem in the body of your post - nobody should have to open an attachment to find out what you want.

No help to be offered until this moderation request is satisfied.