Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

From the screenshots provided, how would I create a formula that says if the Company Code is 01, and GL Acct # is 11100, then

From the screenshots provided, how would I create a formula that says if the Company Code is 01, and GL Acct # is 11100, then pull back the value in Column I?

Company Code D4 and D5

GL Acct. # Column B

Column I (Amount)

image text in transcribedimage text in transcribed A C D m 2 WJ A E A 01 20 5 11100 Due from Operations 6 11200 Due from SCLLC 7 11300 Due from Compliance 8 21100 Due to Operations 9 21000 Due to SCLLC 10 21200 Due to Compliance 11 49100 Service Fee Revenue 12 49200 Royalty Fee Revenue 13 49300 Administrative Fee Revenue 14 89000 Service Fee Expense 15 89100 Royalty Fee Expense 16 89200 Administrative Fee ExpenseA B C D E F G H J 1_ Transaction' Accounting Company Legal Name GLAcct # Acct Description Concatenated Amount Period 2 V Date V Code V Acct V DrtCr] V V 3_ 100 10/8/21 01 A 89000 Service Fee Expense 0189000 $ 75.00 10/1/2110/8/21 4_ 100 10/8/21 01 A 89100 Royalty Fee Expense 0189100 $ 20.00 10/1/2110/8/21 5_ 100 10/8/21 01 A 21200 Due to Compliance 0121200 5 [95.00) 10/1/2110/8/21 6 100 10/8/21 20 E 49100 Service Fee Revenue 2049100 $ [25.00) 10/1/2110/8/21 7 100 10/8/ 21 20 E 49200 Royalty Fee Revenue 2049200 5 [20.00) 10/ 1/2110/8/ 21 8 100 10/8/ 21 20 E 11200 Due from SCLLC 2011200 5 95.00 10/ 1/2110/8/ 21

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Sampling

Authors: Ray Whittington, Dan M Guy, D R Carmichael

5th Edition

047137590X, 9780471375906

More Books

Students also viewed these Accounting questions

Question

What does this look like?

Answered: 1 week ago