Computers and Technology, 03.12.2019 17:31, funnyadriany4

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?

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.

Answers: 1

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 20.06.2019 18:02, Milk18

What are some examples of objects you can browse by in the select browse object options? check all that apply. folders pages graphics comments sections tables documents

Answers: 1

continue

Computers and Technology, 23.06.2019 12:40, melaniem50

Curriculum exam to process a resident's payment, you must click on onesite payments home page. from the a. reports b. my settings o c. transactions o d. rent tab

Answers: 1

continue

Computers and Technology, 24.06.2019 13:00, toshahoskins0098

What are some websites that you can read manga (ex: manga rock)

Answers: 1

continue

Computers and Technology, 24.06.2019 22:00, kingkush85

Difference between ancient and modern mode of information transmission

Answers: 1

continue

Do you know the correct answer?

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