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, 22.06.2019 00:30
These tools give presenters more freedom to move about the room and interact with their audience. laptop computer laser pointer lcd projector remote control
Answers: 2
question
Computers and Technology, 24.06.2019 08:00
How can smart devices benefit businesses, organizations, and social communities in the global marketplace?
Answers: 1
question
Computers and Technology, 25.06.2019 12:30
The term used to describe the shape and layout of a computer component such as a motherboard or hard drive is __ factor?
Answers: 1
question
Computers and Technology, 25.06.2019 16:30
If your job involves creating a positive image for a company in the media, what would your job description be?
Answers: 1
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, 24.11.2021 14:00
question
Computers and Technology, 24.11.2021 14:00
Questions on the website: 13722363