DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The formula used to make the error return value of a function look “pretty” or clean and non-confusing is:
|
|
IFERROR
|
|
|
IF
|
|
|
ERROR
|
|
|
VLOOKUP
|
Explanation:
Detailed explanation-1: -Try using functions instead of operations In this case, try using a function instead. Functions will often ignore text values and calculate everything as numbers, eliminating the #VALUE! error. For example, instead of =A2+B2+C2, type =SUM(A2:C2).
Detailed explanation-2: -When Excel shows ##### because the cell has a negative date or time value, make sure that you: Verify dates and times are positive values when you’re using the 1900 date system. Use a formula to subtract dates or Add or subtract time correctly to avoid negative date or time value results.
There is 1 question to complete.