In the "Pairs" column in the "Transaction Entry", please display "Yes" for transactions between SalesRep "Sioux"...

In the "Pairs" column in the "Transaction Entry", please display "Yes" for transactions between SalesRep "Sioux" and Customer "YTR", and display "No" otherwise (5%)

Solutions

Expert Solution

Hi,

I don't have the data but i have created some dummy data to represent this

So first thing you have to do is check when a cell has SalesRep as Sioux AND your customer is YTR

- first do the logical AND of your two cells = AND($D2="Sioux",$E2="YTR")

it will return the value true or false.

In case if its true you need to print Yes, and if its false you need to print No

you can use IF condition after that. so your formula will be

=IF(AND($D2="Sioux",$E2="YTR") = TRUE, "Yes", "No")

**Please give a thumbs up if you like the explanation, also, let me know if you need more help in the comments.**

venereology answered 5 months ago

Next > < Previous

Related Solutions

Record the following transactions. (If no entry is required for a transaction/event, select "No journal entry...

Record the following transactions. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) 1. (a) Started business by issuing 10,000 shares of common stock for $30,000. (b) Hired Rebecca as an administrative assistant, promising to pay her $2,900 every two weeks. (c) Rented a building for three years at $570 per month and paid six months' rent in advance. (d) Purchased equipment for $5,000 cash. (e) Purchased $1,900 of supplies on...

Record the following transactions. (If no entry is required for a transaction/event, select "No journal entry...

Record the following transactions. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) (a) Started business by issuing 10,000 shares of common stock for $20,000. (b) Hired Rebecca as an administrative assistant, promising to pay her $2,700 every two weeks. (c) Rented a building for three years at $590 per month and paid six months' rent in advance. (d) Purchased equipment for $5,100 cash. (e) Purchased $2,100 of supplies on account....

Determine whether or not each of the following transactions constitutes a BOP entry. If a transaction...

Determine whether or not each of the following transactions constitutes a BOP entry. If a transaction constitutes a BOP entry, indicate whether it can be described as a debit ora credit in the BOP for the U.S. Justify all your responses. i) Mr. Smith, a resident of Wichita, Kansas in the U.S. buys a new Chevrolet Suburban from a local dealership. ii) Mr. Smith also buys solar panels from his friend, Mr. Wu, who is a resident of Chifeng, China....

Required: Consider the following transactions. In the blank column beside the transaction, identify the journal it...

Required: Consider the following transactions. In the blank column beside the transaction, identify the journal it should be recorded in. Use: · S...... for Sales Journal · P...... for Purchases Journal · CR.... for Cash Receipts Journal · CD.... for Cash Disbursements Journal · G.... for General Journal Dec 1 Purchased merchandise on credit (terms 2/10, n/30). Dec 2 The owner of the business invested some office furniture into the business. Dec 3 Sold merchandise on account (terms 2/10, n/30). Dec 4 The owner invested...

Journalize the following transactions for Stillwater Spa Consultants: (If no entry is required for a transaction/event,...

Journalize the following transactions for Stillwater Spa Consultants: (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) Oct. 1 Sold services for $260,000 to customers using debit cards. Assume the bank charges 0.5% for all debit card transactions. 7 Sold services to customers for $29,000 cash. 8 Recorded Visa credit card sales totalling $152,000. Visa applies fees of 2%. 10 Sold $108,000 of services to Edson Community Health Clinic, terms 2/15,...

Journalize the following transactions for Stillwater Spa Consultants: (If no entry is required for a transaction/event,...

Journalize the following transactions for Stillwater Spa Consultants: (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) Oct. 1 Sold services for $90,000 to customers using debit cards. Assume the bank charges 0.5% for all debit card transactions. 7 Sold services to customers for $11,000 cash. 8 Recorded Visa credit card sales totalling $52,000. Visa applies fees of 2%. 10 Sold $38,000 of services to Edson Community Health Clinic, terms 2/15,...

Here are selected transactions of the Escobedo Shipping Service. Record a journal entry for each transaction.

Here are selected transactions of the Escobedo Shipping Service. Record a journal entry for each transaction. TRANSACTIONS 1. Gave a cash refund of $875 to a customer because of a lost package. (The customer had previously paid in cash.) 2. Sent a check for $1,250 to the utility company to pay the monthly bill. 3. Provided services for $8,700 on credit. 4. Purchased new equipment for $6,400 and paid for it immediately by check. 5. Issued a check for $5.300 to pay a creditor on account. 6....

(4). Record the following selected transactions for April in a two-column journal, identifying each entry by...

(4). Record the following selected transactions for April in a two-column journal, identifying each entry by letter. Omit explanation. April (a) On April 1st, received $18,000 from Katie Long, owner. (b) On April 2nd, purchased equipment for $27,000, paying $10,000 in cash and giving a note payable for the remainder. (c) On April 5th, paid $2,300 for rent for April. (d) On April 8th, purchased $1,500 of supplies on account. (e) On April 10th, recorded $9,800 of fees earned on...

Question 3 What will be the double entry for below-mentioned transactions? Complete the table. Transaction Accounts...

Question 3 What will be the double entry for below-mentioned transactions? Complete the table. Transaction Accounts to be debited Accounts to be credited example Bought a van with cheque. Van Bank Purchase furniture with cash. 2. Sold goods to Maniam Trading on credit. 3. Made cash sates. 4. Owner brought in additional capital in the form of a motor vehicle. 5. Made credit purchases from Zarina Enterprises. 6. Paid cash for petrol that is used in delivery van. 7. Received...

Problem 1. Journalize the following selected transactions for April 2013 in a two-column journal. Journal entry...

Problem 1. Journalize the following selected transactions for April 2013 in a two-column journal. Journal entry explanations may be omitted. April 1 Received cash from stockholder, Kevin Marks, in return for stock, $14,000. 2 Received cash for providing accounting services, $9,500. 3 Billed customers on account for providing services, $4,200. 4 Paid advertising expense, $700. 5 Received cash from customers on account, $2,500. 6 Dividends paid, $1,010. 7 Received telephone bill, $900. 8 Paid telephone bill, $900. Date Description Post...

Subjects