What operator is used to create a validation rule? A. – B. / C. < or > D. +
1 answer:
You might be interested in
Answer:
<h2>Option B: #VALUE</h2>is the correct answer.
Explanation:
<h3>Reasons of #VALUE error:</h3>- When cells are not given the expected type of value.
- If cells are left blank unnoticeable or for giving a null value.
- For entering dates and other numerical data in text form.
This type of error can only be fixed by finding the cell in which there is wrong data entered and correct it.
Fixing the #VALUE error is tricky as some functions automatically ignore the data that is invalid.
<h3>EXAMPLE:</h3>- Suppose a cell contains the value as cost of the object and in order to make it 0, NA is inserted into the cell.
- While making total of all the costs, that particular cell might cause #VALUE error.
- Following image attach will help you clear the concept.
I hope it will help you!
