Question

Q. IF functions (5 marks) Reference a YouTube video explaining IF functions. What is an 'IF'...

Q. IF functions
Reference a YouTube video explaining IF functions. What is an 'IF' statement (function)? Provide a simple spreadsheet accounting example showing an IF function for net profit/net loss.

Homework Answers

Answer #1

IF functions allows us to make comparision and provides results on that basis

Format

=If(Condition,"Result if true","Result if false")

If for net profit/Loss

=If(B3>0,"Net Profit","Net Loss")

B3 Cell will contain the amount of profit/loss

If B3 is greater than zero ie positive It will show Net Profit else Net loss

Do let me know if you have any questions.I would be happy to help

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
How do you know what functions to use on your calculator when looking at study problems?...
How do you know what functions to use on your calculator when looking at study problems? For example: A nationwide study indicated that 80% of college students with cell phones send and receive text messages with cell phones. A simple random sample of n = 200 college students with cell phones is obtained. (a) Describe the sampling distribution of ˆp, the sample proportion of college students with cell phones who send or receive text messages with their cell phones. [Hint:...
Please answer all the questions below. Q. What is not true about reference groups? only provide...
Please answer all the questions below. Q. What is not true about reference groups? only provide positive performance. Some people give us a sense of relative satisfaction. Some give us a sense of relatively deprived. People turn to them when evaluating their personal characteristics, attitudes, values, and behaviors. Q. Which sociological perspective is most aligned with the belief that formal organizations are necessary for the proper operation of large and complex societies? 1. the structural functionalist perspective 2. the neo...
(a) What are the five functions of a financial market? (5 marks) (b) Usually, basic financial...
(a) What are the five functions of a financial market? (b) Usually, basic financial markets have five basic functions in a capitalistic economy: For each of the functions cited below, explain how financial markets perform each function in detail. 1. They make it possible for corporations and governmental units to raise capital. 2. They help to allocate capital toward productive uses. 3. They provide an opportunity for people to increase their savings by investing in them. 4. They reveal investors’...
Question (5) In a UCA cash flow statement, what is true if a business did not...
Question (5) In a UCA cash flow statement, what is true if a business did not generate enough cash from normal operations to pay both interest expense and scheduled debt principal? a. Cash after debt amortization is positive. b. Cash flow has increased. c. Cash after debt amortization is negative. d. Cash flow has decreased. Question (6) If Net Cash After Operations is exactly zero on a UCA cash flow statement for the most recent period, the business was able...
QUESTION 1 Which of the following is not a transaction category? Banking Employees and Payroll Customers...
QUESTION 1 Which of the following is not a transaction category? Banking Employees and Payroll Customers and Sales Company Preferences 4 points    QUESTION 2 Which report summarizes what a company has earned and the expenses incurred to earn the income? Balance Sheet Statement of Cash Flows Accounts Payable Report Profit and Loss Statement QUESTION 3 What is the primary objective of accounting? The primary objective of accounting is to provide information to the Internal Revenue Service (IRS) to ensure the...
Complete this in C++ and explain what is being done. 1      Introduction The functions in the...
Complete this in C++ and explain what is being done. 1      Introduction The functions in the following subsections can all go in one big file called pointerpractice.cpp. 1.1     Basics Write a function, int square 1(int∗ p), that takes a pointer to an int and returns the square of the int that it points to. Write a function, void square 2(int∗ p), that takes a pointer to an int and replaces that int (the one pointed to by p) with its...
Task In your accounting career you will be required to analyse current accounting issues and communicate...
Task In your accounting career you will be required to analyse current accounting issues and communicate your theoretical understanding to your professional colleagues and your clients. For this assignment assume that you are the senior accountant working for a major firm. Question 1 - 9 marks (1,500 words) The CEO has forwarded to you an interesting article and requires you to provide her with a deeper theoretical understanding of the issues discussed so that she can fully engage in the...
Closed book and closed notes. 3. Basic Calculators are permitted. 4. Read all instructions and questions...
Closed book and closed notes. 3. Basic Calculators are permitted. 4. Read all instructions and questions carefully. 5. Show all your work. 6. Please place your Coquitlam College Identification Card face up and visible on your desk. 7. Electronic devices including cellular phones must be turned off and put away during the exam. 8. Any student who has a cell phone or other unauthorized electronic device (i.e. laptop, and et cetera.) on their person or around their desk during this...
1.An obligation of a business that represents the claims of others against the assets of he...
1.An obligation of a business that represents the claims of others against the assets of he business is called a(n) * A.asset B.liability C.expense D.revenue E.equity 2.The general journal provides a place for recording * A.the amount of each debit and credit B.an explanation of the transaction C.the transaction date D.the names of the accounts involved E.All of these 3.An exchange of economic consideration between two parties that causes a change in assets, liabilities or equity is called * A.prepaid...
The purposes of this article, capital assets are defined as tangible or intangible assets that are...
The purposes of this article, capital assets are defined as tangible or intangible assets that are used in operations and that have useful lives of more than one year, such as land and improvements to land, buildings and building improvements; vehicles; machinery; equipment; and sewer, water and highway infrastructures. Risk Assessment: A municipality’s capital assets are subject to a number of risks. Local officials must be cognizant of these risks as they seek to effectively manage their municipality’s capital assets....