Question: For the Adjusted Trial balance columns your IF statement (for the DR column) will compare total debits (DR) to total credits (CR) and then if

For the Adjusted Trial balance columns your IF statement (for the DR column) will compare total debits (DR) to total credits (CR) and then if total debits are greater than total credits subtract total credits from the total debits. Reverse this for the CR column.

I can't figure out the excel formula to complete this.

I know its =if(cell referenceA > cell reference THEN I GET LOST

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

I have 6 assignment about accounting capstone class. Its just and one project but its 6 assignment. Here is the document Assignment 1 It might be difficult for you to imagine yourself in a...

I need this 1 assignments done for accounting class. Please complete the following and submit on time. Assignment 1 As a staff accountant at ABC Tax & Accounting Service, you have a number of clients...

51 100 pts Which one of the fixed asset accounts listed below will not have a related contra asset account? Land Building O Office Equipment O Delivery Equipment D Question 52 Prepaid insurance is...

1. The type of account and normal balance of Prepaid Insurance is a. asset, debit b. contra asset, credit c. asset, credit d. contra asset, debit 2. The income statement will present a. revenues less...

I need this 2 assignments done for accounting class. Please complete the following and submit on time. Assignment 1 As a staff accountant at ABC Tax & Accounting Service, you have a number of clients...

Can I please have th Next w4 The ledger of Rios Company contains the following balances: Owners Capital $31,791; Owners Drawings $2,257; Service Revenue $51,822; Salaries and Wages Expense $28,631;...

I need help with my project.It is a big one..if you have time and knowledge in accounting, please take my project case. It is very, very important for me because this is worth 20% of my grade. If you...

I need help with the solutions for this practice set for accounting. CASE STUDY INSTRUCTIONS - Required: PART 1 - Journalize Monthly Transactions 1) Record the transactions for the month in the...

You need to make the Apples Marketing Project in detail

A parent company is a producer of production equipment, some of which is acquired and used by the parents subsidiary companies. The parent offers a discount to the subsidiaries but still earns a...

QUESTION 1 Effective Leaders ( Pty ) Ltd . ' s is not a registered VAT vendor and is not a qualifying manufacturing business. The financial records for the year of assessment ended 2 8 February 2 0 2...

what are the factors that shape your organization external competitiveness to recruit and retain employees

Factors Affecting Conflict

Describe the factors that lead to productive conflict

Understanding Conflict Conflict Triggers