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
give your opinion on if you would trust your accounts with an online bank. Explain why or why not. MANY people do not. MANY peop
blagie [28]
I would not because you never know there could be hackers and they could get your card account and spend your money. If they get your card number and you do turn up with less money there is really nothing you can do about it at that point. That's why I wouldn't trust my money to an online bank. 

                                                   Hope this helps.
                                          Sincerely, Hodctilana
5 0
3 years ago
Read 2 more answers
Documental acerca de los principales materiales que se emplean en la fabricación de medios técnicos utilizados en una oficina.
Diano4ka-milaya [45]

Answer:

Los equipos técnicos utilizados en una oficina y los principales materiales utilizados en su fabricación son;

Equipo de oficina {}    Material utilizado en la fabricación

1) Impresoras;           {}    Acero, aluminio, alambres de cobre, plástico, rodillos

2) Monitor de computadora; {}   Pantalla de vidrio, plástico, cables, placas de circuito, resortes

3) Escáneres;     {}  Alfombra compuesta, mesa de vidrio, carcasa de plástico, cables

4) Copiador;   {}       Carcasa de plástico, contenedor de tóner, placa de vidrio, cables de alimentación

5) Proyector;    {}    Lente de vidrio y carcasa de metal para lámpara, cables de alimentación

6) Desfibradora; {}    Engranajes de plástico, correa de cadena de metal, rodamientos

Explanation:

4 0
3 years ago
Given a integer, convert to String, using String Builder class. No error checking needed on input integer, However do read in th
Gennadij [26K]

Answer:

The program in Java will be:

// Java program to demonstrate working parseInt()  

public class GFG  

{  

   public static void main(String args[])  

   {  

       int decimalExample = Integer.parseInt("20");  

       int signedPositiveExample = Integer.parseInt("+20");  

       int signedNegativeExample = Integer.parseInt("-20");  

       int radixExample = Integer.parseInt("20",16);  

       int stringExample = Integer.parseInt("geeks",29);  

 

       // Uncomment the following code to check  

       // NumberFormatException  

 

       //   String invalidArguments = "";  

       //   int emptyString = Integer.parseInt(invalidArguments);  

       //   int outOfRangeOfInteger = Integer.parseInt("geeksforgeeks",29);  

       //   int domainOfNumberSystem = Integer.parseInt("geeks",28);  

 

       System.out.println(decimalExample);  

       System.out.println(signedPositiveExample);  

       System.out.println(signedNegativeExample);  

       System.out.println(radixExample);  

       System.out.println(stringExample);  

   }  

}

7 0
3 years ago
Based on the unit content and your own ideas, how would you define a video game in your own words? What separates a regular vide
lara31 [8.8K]

Answer:

A video game would be a series of steps to produce or outcome / end in the form of controller a character or the how the game can be played and being able to play it at some level, but a good game would have multiple questions and a hard difficulty maybe even a customizable section for your character or object. In other words a Video game would be a series of steps to produce a outcome from controlling a character and a Good video game would be the same but added a level of difficulty and harder mechanics into the game.

Explanation:

Hope this helped :)

3 0
3 years ago
List two ways that search engines and electronic databases are similar and three ways that search engines and electronic databas
antoniya [11.8K]

Answer:

Explanation: search engine uses system algorithm to search out items or information as required by the user. Example is google, chrome.

Data base are archives where information could be retrieve. Its contain information such as publications, abstract,journals.

Search engine provides wide range of information depending on you request while database are mostly for academics related materials.

Data base- A good place to generate this information is library, archivals while journal, publiications are kept while search engine can be used anywhere you have an internet facilities.

In a data base, information is searched in an organized way. The collections are already well arranged in different cubicle search engine provides wide range of information not organized.

Data base may contain more complex information not easily understood, search engine provides more elaborate answers.

Similarity of the two is that they both provide information.

They are both reliable.

School library is an example of where journals and publication are kept and can be retrived.

6 0
3 years ago
Read 2 more answers
Other questions:
  • Exposing employee and customer personal data to an untrusted environment is an example of:
    9·1 answer
  • You just read an msds for acetic acid. based on what you read, what type of information is included in an msds sheet? record you
    7·1 answer
  • Typohunting is registering a domain name that is similar to a trademark or domain name but that is slightly misspelled in hopes
    5·1 answer
  • At the beginning of this month, the balance of Reed's checking account was $692.35. So far this month, he has received a paychec
    13·2 answers
  • In which phase of the software development process would probing questions be used to verify the problem definition?
    12·1 answer
  • Dustin runs a command at the command line trying to find out what kernel version the system is running. However, it doesn't give
    12·1 answer
  • Tom's Art Supplies used to sell art supplies through mail order catalogs, but the company's order takers often had difficulty de
    9·1 answer
  • Tell me the most scariest website you know and i'll give you brainlest
    5·1 answer
  • Write a program called array1.cpp file that use either regular for loop or range based for loop to display the contents of the a
    14·1 answer
  • Write a class Bug that models a bug moving along a horizontal line. The bug moves either to the right or left. Initially, the bu
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!