answer.
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
vodka [1.7K]
2 years ago
8

This is suppose to be a mathematical function I need to enter into excel. "Enter a formula in cell B10 to return a value of 3500

0 if the Net Profit after tax (Cell B9) is Greater than or equal to 470000 or 1000 if it is not." How do I type this out in excel using the IF function ?

Mathematics
1 answer:
sesenic [268]2 years ago
7 0
The syntax for the IF statement is as follows:
=IF(condition, value if true, value if false)

therefore, we can enter the information from the problem:

=IF($B$9>=470000,35000,1000)

You might be interested in
Circle D is shown. Line segment C D is a radius with length 18 centimeters. Which statements are true regarding the area of circ
saul85 [17]

Answer:

I just took the test, it's 1 and 3

Step-by-step explanation:

3 0
2 years ago
Read 2 more answers
Shelley is self-employed in Texas and recently attended a two-day business conference in New Jersey. After Shelley attended the
MaRussiya [10]

Answer:

The amount deductible by Shelley is $2,929

Step-by-step explanation:

Using the table below as the missing information:

Airfare to New Jersey $ 2,180

Meals $238

Lodging in New Jersey $432

Rental car $198

All the above expenses are fully deductible by Shelley except the meal which is half deductible.

Half of the meal expenses is:

= 238 / 2 = $119

So the amount deductible by Shelley is:

2180 + 119 + 432 + 198

= 2929

Therefore, the amount deductible by Shelley is $2,929

7 0
2 years ago
Bill is considering taking out a loan. He estimates that he can afford monthly payments of $375 for 10 years in order to support
Anuta_ua [19.1K]
For the same payment and term, the lower the interest rate, the more the loan can be. The opposite is also true. The appropriate selection is ...
  B. If the interest rate were 6.8%, the amount of the loan Bill is considering taking out would be less than $33,025.69.


_____
At 6.8%, Bill can afford a loan of $32,585.93.
4 0
2 years ago
If a cone with a diameter of 10 meters has a surface area of 290.6 square meters, find its slant height.
Finger [1]
<h2>Hello!</h2>

The answer is:

The slant height is 13.43 m.

l=13.43m

<h2>Why?</h2>

To solve the problem, we need to use the following equations to calculate the total surface area and the lateral surface area of right cone:

TotalSurfaceArea=LateralSurfaceArea+BaseArea

LateralSurfaceArea=\pi *r*l

Where,

r, is the radius of the cone.

l, is the slant height of the cone.

We are given the following information:

TotalSurfaceArea=290.6m^{2} \\Diameter=10m\\Radius=\frac{1}{2}d=\frac{1}{2}10m=5m

So, calculating the area of the base(circle) in order to find the lateral surface area, we have:

BaseArea=\pi *r^{2} \\\\BaseArea=\pi *5m^{2} =\pi *25m^{2}=79.54m^{2}

Then, substituting the area of the base into the total surface area to calculate the surface area of the cone, we have:

LateralSurfaceArea=TotalSurfaceArea-BaseArea

LateralSurfaceArea=290.6m^{2}-79.54m^{2}

LateralSurfaceArea=211.06m^{2}

Now, calculating the slant height, we have:

LateralSurfaceArea=\pi *r*l

l=\frac{LateralSurfaceArea}{\pi*r }

Substituting, we have:

l=\frac{211.06m^{2}}{\pi*5 }=\frac{211.06}{15.71m }

l=\frac{211.06}{15.71m }=13.43m

Hence, we have that the slant height is 13.43 m.

l=13.43m

Have a nice day!

6 0
2 years ago
a store manager sends an email survey to customers who have registered at the store's websites. Why is this survey biased?​
Shalnov [3]

The survey is biase because it is only surveying shoppers that have registered on the website,.

8 0
2 years ago
Other questions:
  • . A conductor with a diameter of 100 mils has an area of
    13·1 answer
  • What is the image of (−3,4) after the transformation ry=x?
    13·1 answer
  • What is the value of x in the equation 0.7x – 1.4 = –3.5?
    7·2 answers
  • The length of a rectangle is six times its width. if the perimeter of the rectangle is 140 in , find its area.
    7·1 answer
  • Leo had a $30 gift card to use at a coffee shop. He used the entire balance to buy regular-sized coffees, which cost $2, and lar
    8·2 answers
  • The sum of the four angles in a rectangle is always 180 degrees true or false?
    5·2 answers
  • The weight limit of an elevator is 2,200 pounds. Michelle is solving an inequality to determine how many 40-pound boxes she can
    5·2 answers
  • you own a pet supply store, and the total sales in your trading area equal 27,000. Your market share is 45%. What were your sale
    8·2 answers
  • Fill in the Blanks
    8·1 answer
  • Micah and Lucy are in the school play. Micah memorizes 12 lines of the script the first day and 10 lines each day after that. Lu
    8·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!