Need help with IF statement

[alexbecker220]

I'm filling in a GL entry for Quickbooks, and want the debit and credit columns to auto-populate based on if a specific cell is a negative or positive number.

Basically,

If the total of C12 is a negative number, I want it to enter in B24.
If the total of C12 is a positive number, I want it to enter in C24.

Hope this makes sense!

 

[Joe4]

Welcome to the Board!

Place the following formulas in the following cells:

In B24:

=IF(C12<0,C12,"")

In C24:

=IF(C12>0,C12,"")