# If/than formula where if greater than zero it equals zero

I have a column 1 called players fees (example \$1,000)
A column 2 called order revenue (example A \$2,000; Example B \$500)

I want a 3rd column where IF the sum of player fees (column 1) - order revenue (2) is + the 3rd column equals zero. (example \$1,000 - \$500 = \$1,500 but the row would show \$0)
IF the sum of player fees (column 1) - order revenue (2) is - the 3rd column equals the negative number (example \$1,000 - \$2,000 = -\$1,000)

my current formula is: IF (column 1-column 2 = > 0, 0, column 1-column 2)
But itâs still returning the positive numbers.

To explain the purpose here, I want to track how much money I OWE out to players who are owed money (the negative numbers), but not what I am still owed (the positive numbers).

Hi @Ruby_George1 and welcome to the Coda Community!

Itâs much easier for me and others to help you if you share your doc with us. We can take a look into the formulas and everyone can make a copy of the document so we donât get in the way of each other.

Sincerely
Jannis

1 Like

Thanks so much but the reason Iâm not sharing the full doc is because there is a ton of private information about people in there.

here are screenshots of what Iâm talking about

Hey @Ruby_George1 ,
Screenprints donât really help here. What @Jannis means is for you not to share a doc with private data, but to make a small representative dummy doc that resembles the doc where you have a problem. The screenprints show columns that we donât see, so how would you expect to get a proper answer.
If you donât want to take the time to share a doc with the community, I think the people that can really help you are not going to take the time to give you some guidance.

3 Likes

I gotcha - hereâs the dummy sheet, and the one column with the formula Iâm working on is âdue to playersâ

First of all, thank you for sharing your document. This helps a lot!

Unfortunately, I couldnât fully understand what youâre trying to achieve.
Can you please describe it in more detail using the column names you use in your document? Please also define your desired output for better understanding.

Sincerely
Jannis

Thanks @Jannis

Iâm looking to update the formula in âDue to Playersâ

What I want to know is the sum of money I owe to players. If the number is negative in Due to Players, that means I owe them money.
If the number is positive in âDue to playersâ that means they still owe me money so I want to filter the positive numbers out.

Basically Iâm just trying to put money in reserve for what I owe out and want to know ONLY what I owe out to players.

I feel like I understand formulas pretty well but every time I want to do something new like this in Coda I have ask because what I think should work, doesnât! I appreciate all of your help very much.

You wanted to show only the negative Numbers in the Column âDue to playersâ.
After I checked the doc, I noticed that this is already happening.

Did somebody else already change it without commenting, or did you want to achieve something else?

Please check and let me know if you need any more help.

Jannis

thanks so much for helping! Someone made a comment in the document itself that they fixed the formulaâŚ this is the formula now for anybody who is looking:
Withname(
thisRow.[Player Fees]-thisRow.[Orders Revenue],Amount,
If(Amount<0,Amount,ââ)
)

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.