Computers and Technology, 15.12.2019 01:31 TheOriginalMeyah

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,a3135%,if(a3> 500,a3110%,if(a3< 100,a390%,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.

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 09:50

Assume that you have an sorted array of records. assume that the length of the array (n) is known. give two different methods to search for a specific value in this array. you can use english or pseudo-code for your algorithm. what is the time complexity for each algorithm and why?

Answers: 1

Answer

Computers and Technology, 23.06.2019 08:00

Michael has written an e-mail to his employees that describes a new product special that will be introduced to the customers next week. by taking time to make sure the e-mail is well written, logical, and organized, michael has made sure his message has the characteristics of a) effective communicationb) ineffective communicationc) barriers to communicationd) workplace communication

Answers: 2

Answer

Computers and Technology, 23.06.2019 17:00

What are the 12 colors of the spectrum called?

Answers: 1

Answer

Computers and Technology, 24.06.2019 05:30

Someone plzz me which of these defines a social search? a. asking a search engine a question that is answered by a real person on the other sideb. modifying search results based on popularity of a web pagec.modifying search results based on a ranking of a web page

Answers: 2

Answer

You know the right answer?

Celia is typing a nested if function to multiply a cell’s value by different percentages depending o...

Questions