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

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 01:20, karreemgrant2
What is the full meaning of rfid in computer
Answers: 2
image
Computers and Technology, 24.06.2019 14:30, danielweldon1234
When workers demonstrate patience, are able to manage there emotions, and get along with other employees, which skills are being displayed?
Answers: 1
image
Computers and Technology, 25.06.2019 04:30, BIKRAMlawati5544
The word window is an example of a /an
Answers: 1
image
Computers and Technology, 25.06.2019 05:30, genyjoannerubiera
In 3-5 sentences describe how technology business professionals to be more efficient. include examples of hardware and software
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 in other subjects:

Konu
Social Studies, 25.11.2020 20:30
Konu
Physics, 25.11.2020 20:30
Konu
Mathematics, 25.11.2020 20:30
Konu
Computers and Technology, 25.11.2020 20:30