1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
masya89 [10]
3 years ago
13

In cell C15, enter a formula using an IF function to determine if you need a loan. Your available cash is located on the Data sh

eet in cell A3. If the price of the car is less than or equal to your available cash, display "no". If the price of the car is more than your available, cash, display "yes". Use absolute references where appropriate—you will be copying this formula across the row.
Computers and Technology
1 answer:
san4es73 [151]3 years ago
7 0

The IF function allows the user to make logical comparison among values.

The formula to enter in cell 15 is:  

\mathbf{=IF(\$A\$4 > \$A\$3, "yes", "no")}

In Excel, the syntax of an IF function is:

\mathbf{ = IF ( logical_test , [value_if_true] , [value_if_false] ) }

The representation in the above formula is as follows:

  • logical_test  <em>are the values to be compared</em>
  • [value_if_true] <em>is the return value if the condition is true</em>
  • [value_if_false] <em>is the return value if the condition is false</em>

The cells to compare are given as:  Cell A3 and Cell A4

Where cell A4 contains the car price

So, the IF function is:

\mathbf{=IF(A4 > A3, "yes", "no")}

First, the formula checks if the value of A4 is exceeds A3.

  • If true, the function returns "yes"
  • Else, it returns "no"

To make use of the absolute cell referencing., we simply include the dollar sign between the cell names

Hence, the required formula is:

\mathbf{=IF(\$A\$4 > \$A\$3, "yes", "no")}

Read more about IF functions at:

brainly.com/question/16026173

You might be interested in
What is a program that, when installed on a computer, records every keystroke and mouse click?
Mrac [35]
"Key logger" This could be software or hardware that does this.
6 0
3 years ago
Write a Java test program, named TestGuitar, to create 3different Guitars representing each representing a unique test case and
alina1380 [7]

Answer:

Explanation:

//Guitar.java

import java.awt.Color;

import java.lang.reflect.Field;

import java.util.Random;

public class Guitar

     /**

     * these two fields are used to generate random note and duration

     */

     static char[] validNotes = 'A', 'B', 'C', 'D', 'E', 'F', 'G' ;

     static double[] validDuration = 0.25, 0.5, 1, 2, 4 ;

     /**

     * basic guitar attributes

     */

     private int numStrings;

     private double guitarLength;

     private String guitarManufacturer;

     private Color guitarColor;

     public Guitar()

           /**

           * default constructor

           */

           numStrings = 6;

           guitarLength = 28.2;

           guitarManufacturer = Gibson;

           guitarColor = Color.RED;

     

     public Guitar(int numStrings, double guitarLength,

                 String guitarManufacturer, Color guitarColor)

           /**

           * parameterized constructor

           */

           this.numStrings = numStrings;

           this.guitarLength = guitarLength;

           this.guitarManufacturer = guitarManufacturer;

           this.guitarColor = guitarColor;

     

     /**

     * required getters and setters

     */

     public static char[] getValidNotes()

           return validNotes;

     public static void setValidNotes(char[] validNotes)

           Guitar.validNotes = validNotes;      

     public static double[] getValidDuration()

           return validDuration;

     public

4 0
3 years ago
Positive thinkers tend to
andreev551 [17]

Answer:

I would say D hope this helps

3 0
3 years ago
Read 2 more answers
Write a short note on "History of WWW" (word limit = 100-150 words)​
mihalych1998 [28]

Explanation:

it looks like there aren't many great matches for your search

Tip Try using words that might appear on the page that you’re looking for. For example, 'cake recipes' instead of 'how to make a cake'.

I hope you help

4 0
2 years ago
Read 2 more answers
Identify science and technology policies that could be adapted or implemented in the Philippines?​
mina [271]

Answer:

In the Philippines, universities dominate the research arena. So you have scientists who make research for the sake of research.

The private sector may or may not adopt the research. If a research in UP finds a molecule that may kill cancer, we are not sure whether that research will be adopted or not.

We are not sure if that research will be continued to actual creation of a medicine of cancer. This is because our scientists are working in universities and not in actual pharma companies.

In other countries, the scientists build their own companies. So their research go from drug development to actual manufacturing and marketing of medicines.

So when they start a research, you know that in the next 5 to 10 years, these scientists will produce drugs which the public can benefit from.

This is why the Philippine research is not thriving as it should. Our government should support our start ups.

When scientists are given grants for research, they should also be given grants to start their company. Unfortunately, start up grant is not a function of the DOST. It is of the DTI.    

Explanation:

6 0
2 years ago
Other questions:
  • If someone receives a shock, or a piece of equipment is throwing sparks or arcing you should try to pull them away from the sour
    7·1 answer
  • You find that you are missing a very important file. After much searching, you have determined that it is no longer on your comp
    13·2 answers
  • - If we place records from different tables in adjacent____________, it would increase efficiency of a database.
    14·1 answer
  • In python:
    14·1 answer
  • A(n) _____ is a computer program that can damage files and programs on your computer.
    6·2 answers
  • What function should be entered into B7 to calculate the total budget
    15·2 answers
  • David Doe is a network administrator for the ABC Company. David is passed over for promotion three times. He is quite vocal in h
    14·1 answer
  • 1.) Florida has ____________ roads that are designated as part of the National Highway System.
    12·1 answer
  • If you're a beginner to data analysis, what is the first thing you should check when you build data queries?
    11·1 answer
  • PLEASE HELP!
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!