Which function is used to trap and handle errors in Excel...
Which function is used to trap and handle errors in Excel?
IFERROR()
ERROR()
IFNA()
IFTRAP()
IFERRORTHENTRAP()
Correct answer is A
The IFERROR() function is used to trap and handle errors.
Syntax:
=IFERROR (value, value_if_error)
Example:
=IFERROR (A2/C2,"Please enter a value in C2")
Which key stroke is used to move the active cell towards left, in an Access table ? ...
What is the correct way to refer to cell A10 on sheet3 from sheet1? ...
In Excel, how can you remove borders applied in cells? ...
In an Excel worksheet, you can select ...
Cascade update option in Access ...
What is the default paper size in Microsoft Word? ...
Which animation(s) is/are used to make text appear one line at a time in a presentation? ...