Answered step by step
Verified Expert Solution
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)
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/ 21Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started