needing an if and an and

Thank you JBeaucaire, this is my first time on here so i appreciate any advice.
On my original request i have posted the new thread title and uploaded the 10 column worksheet i am working on. I will cell reference all the financial statements on my own but i cannot figure out the formula for the debit and credits columns in the income statement and the balance sheet. Any help you can provide would be greatly appreciated.

JB i understand your response but the 100"s are nonrelevant. you can insert any data you like. maybe this will help clarify what i need. i need the exact same formula in the Income Statement debit column for each and every row. The same goes for the other three columns, Income statement credit column, balance sheet debit column, and the balance sheet credit column. Each column should have a slightly different formula but within a column the formula must be the same for all line items. My balance sheet and income statement columns in the 10 column worksheet must include an IF and an AND. this formula must check to see if the account number begins with the numbers associated with an asset, liability, or owner's equity and check to see if the account has a debit or credit balance, to place it in the right column. I hope this helps you in aiding me to solve this problem. again thank you for taking the time to assist me.

JB i know this is probably frustrating to you, it is to me as well. I do not have a set of values to insert in the worksheet. my goal is to be able to record values for each account at the end of the month in the unadjusted trial balance. Also i will insert values that are adjusting. I have a formula in place for the adjusted trial balance. What i can't seem to figure out is the formulas that are needed in the income statement debit and credit columns and the balance sheet debit and credit columns. By having these formulas in place i will cell reference my actual finance statements to autofill from the information on the 10 column worksheet. Is there any other info i can give you to help? Basically i am trying to set it up so that at the end of every month i can plug in the numbers to the unadjusted trial balance and the adjusting entries and the rest of the worksheet will autofill. i hope this helps.

Hello,
I think i know what you are trying to say. But for you to do that, you need to have somewhere (in another sheet or somewhere else in the same sheet) if the accounts in Col B are a Debit or Credit balance.
PS: You shouldnt have the Acc. Depreciation of your equipment as a Debit Account. And the totals on Col C and D should be the same...Your data seems a bit weird.

Heya Badger,
Suggestion.

What you need to do is show us what's called a "Hard Code"
It's when you type in the values you're going to enter, then manually enter the results expected. That lets us find a way to do it through code.

See the attached example of a hard coded worksheet

i would like to thank everyone who tried to help me but i have the problem solved. using an IF and an AND formula i was able to determine which amount on the adjusted balance sheet went to what column in the income and balance debit and credit column. this is the formula i used for the income debit column. IF(AND(G6>0,A6>400)G6,0) I had to refer to the account numbers to verify which column the amount went into.(A6>400) Very frustrating to figure out but it works for that column all the way down and automatically fills in the appropiate cells. then the other 3 columns have a similar formula but the cell references in the formula are slightly different. Again thanks to all who tried to help.