IF function Help

Question

Can someone help me figure out what the formula is for this question.

In cell K5, enter a nested IF function that produces the result “Owing” if the value of cell J5 (Balance) is greater than 0 (zero), “Credit” if the Balance is less than 0, and “Paid Up” otherwise.

It is suppose to look like this in the "Status".

Answer 1

Here is what I changed it to if the above doesn't work for you:

=IF([@Balance]>0,"Owing",IF([@Balance]<0,"Credit","Paid Up"))

Answer 2

I fixed it and it is saved at your link above. It was having problems because it was a table, so I changed it to use table references instead of cell references.

Answer 3

Here is the link through onedrive.

Tsang Student Accounting.xlsx

Answer 4

Can you save a copy of your workbook to OneDrive and share it and post the link here?

Answer 5

My first cell ends up being "Paid up", when is it suppose to be "Owing" status. Also, anything that is in a negative balance is not showing as a "Credit" and showing up as "owing".