Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 27, 2024

Please modify this formula so it works in excel if(f5=6 and f83=0,f43,round((f43+f83)/2/10,0)*10)

Please modify this formula so it works in excel

if(f5=6 and f83=0,f43,round((f43+f83)/2/10,0)*10)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

OCA Oracle Database SQL Exam Guide Exam 1Z0-071

Authors: Steve O'Hearn

1st Edition

1259585492, 978-1259585494

More Books

Students also viewed these Databases questions

Question

★★★★★

Every year there is a shortage of Super Bowl tickets at the official prices P0. Generally, a black market (known as scalping) develops in which tickets are sold for much more than the official price....

Answered: 1 week ago

Question

★★★★★

- Understand why it is important to process adjusting entries

Answered: 1 week ago

Question

★★★★★

31. A concert has three pieces of music to be played before intermission. The time taken to play each piece has a normal distribution. Assume that the three times are independent of one another. The...

Answered: 1 week ago

Question

★★★★★

Halsey Company sells women's clothing. Halsey's strategy is to offer a wide selection of clothes and excellent customer service and to charge a premium price. Halsey presents the following data for...

Answered: 1 week ago

Question

★★★★★

If the nominal return on an investment of common stocks was 35% and inflation was 6% annually, what was the real return on common stock? (eep 4 decimal places)

Answered: 1 week ago

Question

★★★★★

Denise is 22 years old. She thinks she will need $2,100,000 to retire in 45 years. How much must she save every month if she can earn 10%? $1,970.81 $243.43 $2,921.11 $200.33

Answered: 1 week ago

Question

★★★★★

001 (part 1 of 3) 10.0 points The scale on the horizontal axis is 3 s per divi- sion and on the vertical axis 3 m per division. 5 position (x 3 m) 0 1 23 4 5 6 7 time (x 3 s) What is the time...

Answered: 1 week ago

Question

★★★★★

Sandeep Parikh purchased a variable life ( VL ) insurance policy from the Homerun Insurance Company. Assuming Mr . Parikh's policy is a typical VL policy, it is correct to say that the subaccount...

Answered: 1 week ago

Question

★★★★★

Calculate mean, median, standard deviation, minimum, maximum, and counts (n) for all variables in the POS Associates data set that are appropriate (i.e., that are quantitative variables or are...

Answered: 1 week ago

Question

★★★★★

Demetri lives in the city and sometimes uses a ride share service. A ride costs $1.50 for the first mile and $0.25 for each additional mile. Demetri does not want to spend more than $3.75 on a ride....

Answered: 1 week ago

Question

★★★★★

Required information Exercise 12-12 (Algo) Indirect: Preparing statement of cash flows LO P2, P3, A1 [The following information applies to the questions displayed below.] The following financial...

Answered: 1 week ago

Question

★★★★★

5.31 The number of hits per day on the Web site of Professional Tool, Inc., is normally distributed with a mean of 700 and a standard deviation of 120. a. What proportion of days has more than 820...

Answered: 1 week ago

Question

★★★★★

5.30 A broadcasting executive is reviewing the prospects for a new television series. According to his judgment, the probability is 0.25 that the show will achieve a rating higher than 17.8, and the...

Answered: 1 week ago

Question

★★★★★

5.35 A company services copiers. A review of its records shows that the time taken for a service call can be represented by a normal random variable with a mean of 75 minutes and a standard deviation...

Answered: 1 week ago

Previous Question Next Question