Trusted by millions of Kenyans
LoginRegister
Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Browse exam papers
Or go directly to:
Class notes Holiday assignments Topical questions Other resources

What are the possible causes of the #VALUE! error?

Explain the possible cause of the #VALUE! error.

Answers

Maurice
(i) Entering text when the formula requires a number or a logical value, such as TRUE or FALSE.

(ii) Microsoft Excel cannot translate the text into the correct data type. For example, if cell A5 contains a number and cell A6 contains the text "Not available", the formula=A5+A6 will return the error #VALUE!.

(iii) Entering or editing an array formula, and then pressing ENTER.

(iv) Entering a cell reference, a formula, or a function as an array constant.

(v) Supplying a range of operator or a function that requires a single value, not a range.
maurice.mutuku answered the question on April 10, 2018 at 06:03

Answer Attachments

Next: How can you clear as well as edit a cell's content in Excel?

Previous: What is 'Worksheet formatting?'

View more Computer Studies Questions and Answers  |  Return to Questions Index

Exams With Marking Schemes

Related Questions