Question
In: Computer Science
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 10 months agoRelated 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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Why would UnderArmour want to be sure that consumers can clearly see different models ( about...
- Five years ago, Miguel invested a stock with price $35 per share. The stock price at...
- You are touring a distant planet on which the magnitude of the gravitational acceleration is 65%...
- GDP increased from $16.55 trillion to $17.28 trillion. What was the growth rate of GDP? The...
- Forming an Accountable Care Organization in a hospital setting What is an ACO and its reimbursement?...
- Implement a method that meets the following requirements: (a) Has the same requirements as the above...
- The Good’n’Fresh Grocery Store has two checkout lanes and four employees. Employees are equally skilled, and...
ADVERTISEMENT