subject
Mathematics, 28.09.2019 19:00 angienunez2983

Ineed with creating an if function (excel)
in cell d19, use an if function. the conditions are • if the number in cell d18 is over 500, then insert 0. • if the number in cell d18 is under 500, then insert 5% of the number in cell d18 (hint: d18*.05). when answering my question someone replied with this "=if(d18> 500,0.05*d18)" which equaled 96.9335 which is incorrect the answer should be $1,938.67 !

ansver
Answers: 1

Another question on Mathematics

question
Mathematics, 21.06.2019 14:30
Part of the total score for each program is the sum of five program component scores. on the free program, the sum of these five program component scores is multiplied by a factor of 2.0. yuzuru hanyu, of japan, earned scores of 9.07, 8.96, 8.89, 9.21, and 9.36 for the program components portion of his free program. how many total points did he receive for this portion?
Answers: 1
question
Mathematics, 21.06.2019 14:40
Sara sells beaded necklaces she makes a profit of 4 dollars pn every neclace she sells which table represents the profit sara makes
Answers: 1
question
Mathematics, 21.06.2019 19:40
It appears that people who are mildly obese are less active than leaner people. one study looked at the average number of minutes per day that people spend standing or walking. among mildly obese people, the mean number of minutes of daily activity (standing or walking) is approximately normally distributed with mean 376 minutes and standard deviation 64 minutes. the mean number of minutes of daily activity for lean people is approximately normally distributed with mean 528 minutes and standard deviation 107 minutes. a researcher records the minutes of activity for an srs of 7 mildly obese people and an srs of 7 lean people. use z-scores rounded to two decimal places to answer the following: what is the probability (image for it appears that people who are mildly obese are less active than leaner people. one study looked at the averag0.0001) that the mean number of minutes of daily activity of the 6 mildly obese people exceeds 420 minutes? what is the probability (image for it appears that people who are mildly obese are less active than leaner people. one study looked at the averag0.0001) that the mean number of minutes of daily activity of the 6 lean people exceeds 420 minutes?
Answers: 1
question
Mathematics, 21.06.2019 22:50
He graph of f(x) = |x| is stretched by a factor of 0.3 and translated down 4 units. which statement about the domain and range of each function is correct? the range of the transformed function and the parent function are both all real numbers greater than or equal to 4. the domain of the transformed function is all real numbers and is, therefore, different from that of the parent function. the range of the transformed function is all real numbers greater than or equal to 0 and is, therefore, different from that of the parent function. the domain of the transformed function and the parent function are both all real numbers.
Answers: 3
You know the right answer?
Ineed with creating an if function (excel)
in cell d19, use an if function. the conditions ar...
Questions
Questions on the website: 13722360