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
Bumek [7]
3 years ago
6

In cell F15, insert a function that will automatically display the word Discontinue if the value in cell D15 is less than 1500,

or the text No Change if the value in cell D15 is greater than or equal to 1500.
Computers and Technology
1 answer:
777dan777 [17]3 years ago
3 0

Answer:

=IF(D15<1500, "Discontinue", "No Change")

Explanation:

Assuming that this is excel, you can locate the cell F15 and input the IF function. The formula for IF function is

IF(<condition>, <action if true>, <action if false>)

So before the 1st comma, we place the condition which is D15 < 1500

In the middle, before the 2nd comma, we place the text to display if D15 is less than 1500, which is "Discontinue".

In the last place, we place the text to display if D15 is greater than or equals to 1500, which is "No Change"

So the overall formula is =IF(D15<1500, "Discontinue", "No Change")

You might be interested in
Consider the following method:
Katen [24]

Answer:

See explaination

Explanation:

public class Main {

public static void main(String[] args) {

//execution starts from here so initializing the try block for erros

try{

Scanner keyboard = new Scanner(System.in);

System.out.print("Please enter a file name: ");

String name = keyboard.next();

//the line below throws file not found exception if the given file name is not found or unable to open

Scanner file = new Scanner(new File(name));

String line = file.nextLine();

int n = file.nextInt();

//the below print line function call throws ParameterNotAllowedException if n is zero

printLine(line, n);

}//all Exceptions potentially thrown

catch(InputMismatchException e){

System.out.println("User input type mismatch\n"+e);

}catch(FileNotFoundException e){

System.out.println("Given file name is wrong or does not match");

}catch(ParameterNotAllowedException e){

System.out.println("The n given to printLine must be more than zero");

}catch(IOException ex){

System.err.println("An IOException was caught!");

}

}

//method from above goes here.

public static void printLine(String line, int numberOfTimes) throws Exception {

if (numberOfTimes <=0)

throw new ParameterNotAllowedException("Error. invalid parameter.",numberOFTimes);

for( int i=0; i<numberOfTimes; i++)

System.out.println(line);

}

}

For the user written custom Exception ParameterNotAllowedException. We need to add an exceptional class.

Which is missing from the given info:

class ParameterNotAllowedException extends Exception

{

public ParameterNotAllowedException(String s,int n)

{

// Call constructor of parent Exception

super(s);

}

}

8 0
3 years ago
Read 2 more answers
Write a program to find a peak in an array of ints. Suppose the array is {-1, 0, 2, 5, 6, 8, 7}. The output should be "A peak is
Sergeeva-Olga [200]

Answer:

Following are the code to this question:

#include<iostream>//declaring header file  

using namespace std;

int main()//main method

{

int n= 6,j=0;//declaring integer variable

int X[n];//defining an array

for(j=0;j<=n;j++)//defining a loop for input value

cin>>X[j];//input value from the user

if(j==0) //defining if block that checks value at beginning

{

if(X[j]>=X[j+1])//defining if block to check to compare first and second value  

{

cout<<"A peak is at array index "<<j<<" and the value is "<<X[j];//use print method to largest value with index number  

}

}

else//defining else block

{

for(j=0;j<=n;j++)//defining for loop for compare other value

{

if(j==n-1) //use if block that checks next index  

{

if(X[j]>=X[j-1])//use if block to compare value  

cout<<"A peak is at array index "<<j<<" and the value is "<<X[j];//use print method to largest value with index number

}

else

{

if(X[j]>=X[j-1] && X[j]>=X[j+1])//comapre value

cout<<"A peak is at array index "<<j<<" and the value is "<<X[j];//use print method to largest value with index number

}

}

}

return 0;

}

Output:

please find the attached file.

Explanation:

In the given code, inside the main method two integer variable "n and j", is declared, in the next step, an array "x"is defined which input the value from the user end.

  • In the next step, multiple if block is used, in the first if block it comapre the first and second value if it grater then it will print the value with its index number.
  • In the next if block, it comapre is next value and if it grater then it will print the value with its index number.  

5 0
3 years ago
Pages with obvious problem with functionality or errors in displaying content
Shkiper50 [21]
The answer is Low-Quality Pages.
Low-quality pages have an obvious problem with functionality or errors in displaying content. Low-Quality Pages also has poor page layout. Spaces in low quality pages are not used well. Usually, these pages lack some aspects of a website.
6 0
4 years ago
Lists are indexed by an ________. a. float b. integer c. string d. All of the above​
bixtya [17]
All of above?

May be but not sure.
4 0
3 years ago
Need help answering this
elena55 [62]
I think it is c if that helps x
3 0
3 years ago
Other questions:
  • A company that wants to send data over the Internet has asked you to write a program that will encrypt it so that it may be tran
    6·1 answer
  • You tell pavel that he needs to set up a wi-fi network whose range will need to be about 350 feet. pavel tells you that you need
    14·1 answer
  • The ability to keep web page visitors at your site is called _______.
    11·1 answer
  • Output devices reproduce or display which of the following
    12·2 answers
  • You have an email that you are sending to a friend. You want to ensure it retains its integrity during transit, so you decide to
    5·1 answer
  • 4. You are planning to buy a new couch for your family room. Before you leave for the furniture store, you measure the available
    11·1 answer
  • How to turn on a computer
    9·1 answer
  • What is a frame injection attack in a wireless network?
    13·2 answers
  • Which network protocol is used to handle the reliable delivery of information?
    5·1 answer
  • The SQL SELECT built-in function COUNT ____.
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!