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?

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

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 24.06.2019 01:00
How can the temperature of a room be raised by 5degreesf?
Answers: 1
question
Computers and Technology, 24.06.2019 20:10
Approximately what portion of global employers tends to use social media websites to hire new employees?
Answers: 1
question
Computers and Technology, 25.06.2019 00:30
Which of these serves as a bridge between the programming team and the audio team?
Answers: 2
question
Computers and Technology, 25.06.2019 04:00
Has anyone noticed that has been giving the wrong answers and that the ads are blocking answers or is that just me?
Answers: 2
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
English, 17.01.2022 14:00
question
Mathematics, 17.01.2022 14:00
question
SAT, 17.01.2022 14:00
question
Mathematics, 17.01.2022 14:00
Questions on the website: 13722363