"IF" How to use the IF function

  • Thread starter Thread starter Elizabeth
  • Start date Start date
E

Elizabeth

I have two columns, one is composed of debits and the
other one of credits, but not both.

Some debits need to be posted to the Income statements
Some debits need to be posted to the balance sheet

Some credits need to be posted to the income statements
Some credits need to be posted to the balance sheet


On the instructions it says that I need to use the IF
function. I need the formulas to be able to treal
balance sheet accounts differently than income statement
accounts. The formula needs some way to differentiate
the two types. The professor suggested account numbers
with different ranges for the two categories. But I
don't know how to write the formula. I already added a
column and for each acct name has an acct#. What should
I do?

Thank You
 
Hi Elizabeth!

Your account numbers for different categories of debits and credits
must allow distinction between those that go to income statements and
those that go to balance sheet.

Also, how are you signing the amounts? If you're using negatives for
debits and positives for credits, there's no problem making a
distinction between the them. But if they are all positive, you need
your account numbers to distinguish between debits and credits as
well.

If the above rules have been followed by your numbering system, it
won't be too difficult to set up a four way IF function that splits
the amounts into four separate columns each with formulas as follows:

eg. debits to income statements numbered 1-999
=IF(A1="","",IF(A1<1000,A1,""))
eg. debits to balance sheet numbered 1000-1999
=IF(A1="","",IF(AND(A1>=1000,A1<2000),A1,""))
eg. credits to income statements numbered 2000-2999
=IF(A1="","",IF(AND(A1>=2000,A1<3000),A1,""))
eg. credits to balance sheet numbered 3000-3999
=IF(A1="","",IF(A1>=3000,A1,""))
 
Back
Top