subject

Celia is typing a nested if function to multiply a cell’s value by different percentages depending on the cell’s specific value. however, the function is not working properly.

if(a3> 750,a3*135%,if(a3> 500,a3*110%,if(a3< 100,a3*90%,a3)

what is the most likely reason why excel is not recognizing this nested function?

celia should have used colons instead of commas.
the * symbol is not recognized in microsoft excel.
celia did not use enough parentheses.
percentages must be written as decimals.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 21:00
You should hand write your references on your resume.
Answers: 1
question
Computers and Technology, 22.06.2019 00:30
At an open or uncontrolled intersection, yield if a. the cross road has more lanes than yours b. the cross road has fewer land than yours c. you’re on a state highway and the cross road is a secondary road d. do you have three or more passengers in your vehicle
Answers: 2
question
Computers and Technology, 22.06.2019 00:50
Is one of the most injurious events that can happen to a person in a crash.
Answers: 1
question
Computers and Technology, 23.06.2019 01:00
Let r be a robotic arm with a fixed base and seven links. the last joint of r is a prismatic joint, the other ones are revolute joints. give a set of parameters that determines a placement of r. what is the dimension of the configuration space resulting from your choice of parameters?
Answers: 3
You know the right answer?
Celia is typing a nested if function to multiply a cell’s value by different percentages depending o...
Questions
question
Mathematics, 17.02.2021 19:30
question
Health, 17.02.2021 19:30
question
Social Studies, 17.02.2021 19:30
question
Mathematics, 17.02.2021 19:30
question
Mathematics, 17.02.2021 19:30
question
Geography, 17.02.2021 19:30
Questions on the website: 13722360