How to show a zero in a cell when using an IF statement comparing cells

[taichi56]

I have a balance sheet that uses the following formula:

Please Login or Register  to view this content.

Ok with this formula if M39 is $200.00 and M40 is the amount advanced $242.00 then cell M43 should show that the employee owes payroll $42.00. But it does not show anything. It will only show what payroll owes employee if M39 is $350.00 and M40 is $242.00 then payroll owes employee $108.00 and it shows that. How can I get M43 to show the amount when the employee owes payroll? thank you.

[FDibbins]

I think you have your logic the wrong way round...
=IF(M40>M39,M39-M40,0)
0r
=IF(M40<M39,0,M39-M40)

[taichi56]

Maybe I am not putting it in the cell correctly. But if I put in the first part of the formula that you gave me then the Employee is owed money from payroll works. But if I put in the complete formula adding the second part i get a #VALUE then nothing works. Thank you for the help.

[FDibbins]

	M
39	200
40	242
41
42
43	-42
44	42

M43=IF(M40>M39,M39-M40,0)
M44=IF(M40>M39,M40-M39,0)

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[taichi56]

That worked perfectly. Thank you very much for your patience and help.

[FDibbins]

Happy to help, thanks for the feedback