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
Oliga [24]
3 years ago
15

Enter a formula in cell B10 to return a value of 35000 if the Net Profit After Tax (cell B9) is greater than or equal to 470000

or 1000 if it is not.
Computers and Technology
2 answers:
FrozenT [24]3 years ago
6 0

Statement to be written in cell B10 :

IF ( B9 >= 470000, 35000, 1000)

Formula:

IF ( logical_test ,  [value_if_true] ,  [value_if_false] )

Explanation:

  1. logical_test = Net Profit After Tax (cell B9)
  2. value_if_true = 35000

<em>(if the Net Profit After Tax (cell B9) is greater than or equal to 47000 )</em>

<em>     </em>3<em>.</em> value_if_false = 1000

<em>(if the Net Profit After Tax (cell B9) is lesser than 47000 )</em>

Each value should be separated by comma.

vaieri [72.5K]3 years ago
6 0

The formula written to cell B10 is

IF (B9> = 470000, 35000, 1000)

IF (logical_test, [value_if_true], [value_if_false])

<h2>Further Explanation </h2>

The IF function is one of the most popular functions in Excel, which allows you to make logical comparisons between values ​​and estimates.

Therefore, IF statements can have two results. The first result if your comparison is True and the second result if the comparison is False.

For example, = IF (C2 = "Yes", 1,2) means IF (C2 = Yes, then give 1, if not give 2).

<h3>= IF (C2 = 1, "Yes", "No") </h3>

In this example, the formula in cell D2 says: IF (C2 = 1 then give Yes, if not give No) As you can see, the IF function can be used to evaluate text and values. The IF function can also be used to evaluate errors. You are not limited to only checking if one thing is the same as another and giving one result, you can also use a mathematical operator and do other calculations depending on your criteria. You can also stack multiple IF functions together to do multiple comparisons.

<h3>= IF (C2> B2, "Exceeding Budget", "In Budget") </h3>

In the example above, the IF function in D2 says IF (C2 Is Greater Than B2, returns "Exceeds Budget", if not returns "In Budget")

Learn More

IF in Excel brainly.com/question/11853071

The Formula brainly.com/question/11853071

Details

Class: High School

Subject: Computers and technology

Keyword: IF, excel, formula

You might be interested in
Write pseudo code that performs the following: Ask a user to enter a number. If the
CaHeK987 [17]
Answer:
BEGIN
INPUT N
IF N>0 AND N<10 THEN
OUTPUT "blue"
ELSE
IF N>10 AND N<20 THEN
OUTPUT "red"
ELSE
IF N>20 AND N<30 THEN
OUTPUT "green"
ELSE
OUTPUT "It is not a correct color option"
ENDIF
END.

Explanation:

3 0
2 years ago
Describe the pace of change in ICT
densk [106]

Answer:

Information and communications technology is an extensional term for information technology that stresses the role of unified communications and the integration of telecommunications and computers, as Technology Trends 2016

#1: Spreading intelligence throughout the cloud. ...

#2: Self-managing devices. ...

#3: Communication beyond sight and sound. ...

#4: Fundamental technologies reshaping what networks can do. ...

#5: Weaving security and privacy into the IoT fabric.

Explanation:

look for a question that i have answered answer it and also plz give me brainliest on this one plz

4 0
3 years ago
Which of the following processes allows animators to use computers to input human movement that can later be transformed to crea
nadya68 [22]
Motion Capture. "it's a combination of rotoscoping with newer computer technology, allowing people to use live footage as the basis for animation without having to go through the process of drawing over it." -scienceworld .ca
7 0
2 years ago
Read 2 more answers
To create a formula in______, you would first click in one of the cells​
Pavlova-9 [17]

Answer:excel

Explanation:

5 0
4 years ago
Read 2 more answers
Compare the elements of the basic Software Development Life Cycle with 2 other models. How are they similar? How are they differ
Artemon [7]

Answer:

Explanation:

One of the basic notions of the software development process is SDLC models which stands for Software Development Life Cycle models. SDLC – is a continuous process, which starts from the moment, when it’s made a decision to launch the project, and it ends at the moment of its full remove from the exploitation. There is no one single SDLC model. They are divided into main groups, each with its features and weaknesses. The most used, popular and important SDLC models are given below:

1. Waterfall model

2. Iterative model

3. Spiral model

4. V-shaped model

5. Agile model

Stage 1. Planning and requirement analysis

Each software development life cycle model starts with the analysis, in which the stakeholders of the process discuss the requirements for the final product.

Stage 2. Designing project architecture

At the second phase of the software development life cycle, the developers are actually designing the architecture. All the different technical questions that may appear on this stage are discussed by all the stakeholders, including the customer.  

Stage 3. Development and programming

After the requirements approved, the process goes to the next stage – actual development. Programmers start here with the source code writing while keeping in mind previously defined requirements. The programming by itself assumes four stages

• Algorithm development

• Source code writing

• Compilation

• Testing and debugging

Stage 4. Testing

The testing phase includes the debugging process. All the code flaws missed during the development are detected here, documented, and passed back to the developers to fix.  

Stage 5. Deployment

When the program is finalized and has no critical issues – it is time to launch it for the end users.  

SDLC MODELS

Waterfall – is a cascade SDLC model, in which development process looks like the flow, moving step by step through the phases of analysis, projecting, realization, testing, implementation, and support. This SDLC model includes gradual execution of every stage completely. This process is strictly documented and predefined with features expected to every phase of this software development life cycle model.

ADVANTAGES  

Simple to use and understand

DISADVANTAGES

The software is ready only after the last stage is over

ADVANTAGES

Management simplicity thanks to its rigidity: every phase has a defined result and process review

DISADVANTAGES

High risks and uncertainty

Iterative SDLC Model

The Iterative SDLC model does not need the full list of requirements before the project starts. The development process may start with the requirements to the functional part, which can be expanded later.  

ADVANTAGES                                        

Some functions can be quickly be developed at the beginning of the development lifecycle

DISADVANTAGES

Iterative model requires more resources than the waterfall model

The paralleled development can be applied Constant management is required

Spiral SDLC Model

Spiral model – is SDLC model, which combines architecture and prototyping by stages. It is a combination of the Iterative and Waterfall SDLC models with the significant accent on the risk analysis.

4 0
3 years ago
Other questions:
  • What are the two different frequencies WiFi operates on?
    9·2 answers
  • Tim has an old server computer that his company uses as a backup. One of the hard drives has gone bad and needs to be replaced.
    13·1 answer
  • Who are the founders of Microsoft?
    5·1 answer
  • How does the text recommend that a company operate if it wants to be successful in the information age?
    11·1 answer
  • Before measuring resistance of a component, be sure:
    8·1 answer
  • Explain the role of a computer in education​
    9·1 answer
  • Briefly explain specialisation?​
    11·1 answer
  • Please write a Java program to read movies.txt file. (It is in Modules under Chapter Code) Create your own movies.ser file from
    14·1 answer
  • Edhesive 9.3 code practice
    11·1 answer
  • FoRWarD MaRcH AND hERe We Go MEMbers of the agEncy BaKuGO AHHHHHHHHH-
    10·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!