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,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.
Answers: 1
Another question on Computers and Technology
Computers and Technology, 22.06.2019 08:10
Technician a says that if a valve is open when a piston rises to the very top of a cylinder, the piston may actually strike the valve head and cause serious engine damage. technician b says if the camshaft is located in the engine block, then the engine is called an overhead valve engine, ohv engine, or an in-block camshaft. who is right? a. b only b. both a and b c. a only d. neither a nor b
Answers: 3
Computers and Technology, 24.06.2019 07:30
Jason is working on a microsoft excel worksheet and he wants to create a print preview shortcut. his teacher asks him to access the customization option to create the new shortcut. which two tabs should jason select to place the print preview shortcut on the worksheet toolbar? a. new tab (custom) and new group (custom) b. new file tab (custom) and new tab (custom) c. new custom group and new command d. new custom tab and new command
Answers: 2
Computers and Technology, 24.06.2019 10:10
Which view in a presentation program displays a split window showing the slide in the upper half and a blank space in the lower half?
Answers: 1
Computers and Technology, 24.06.2019 13:00
What are some websites that you can read manga (ex: manga rock)
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
Mathematics, 10.12.2020 01:00
Mathematics, 10.12.2020 01:00
Arts, 10.12.2020 01:00
Biology, 10.12.2020 01:00
Advanced Placement (AP), 10.12.2020 01:00
Mathematics, 10.12.2020 01:00
English, 10.12.2020 01:00
Mathematics, 10.12.2020 01:00
History, 10.12.2020 01:00
