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 with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Mathematical Statistics With Applications In R

Authors: Chris P. Tsokos, K.M. Ramachandran

2nd Edition

124171133, 978-0124171138

Students also viewed these Accounting questions