Question

What is error ?deffine its role in the formula .

Answer 1

ᴜsᴇ ᴛʜᴇ ɪғᴇʀʀᴏʀ ғᴜɴᴄᴛɪᴏɴ ɪɴ ᴇxᴄᴇʟ ᴛᴏ ʀᴇᴛᴜʀɴ ᴀɴ ᴀʟᴛᴇʀɴᴀᴛɪᴠᴇ ʀᴇsᴜʟᴛ, sᴜᴄʜ ᴀs ᴛᴇxᴛ, ᴡʜᴇɴ ᴀ ғᴏʀᴍᴜʟᴀ ᴇᴠᴀʟᴜᴀᴛᴇs ᴛᴏ ᴀɴ ᴇʀʀᴏʀ. 1. ғᴏʀ ᴇxᴀᴍᴘʟᴇ, ᴇxᴄᴇʟ ʀᴇᴛᴜʀɴs ᴛʜᴇ #ᴅɪᴠ/0! ... ɪғ ᴛʜᴇ ғᴏʀᴍᴜʟᴀ ᴅᴏᴇs ɴᴏᴛ ᴇᴠᴀʟᴜᴀᴛᴇ ᴛᴏ ᴀɴ ᴇʀʀᴏʀ, ᴛʜᴇ ɪғᴇʀʀᴏʀ ғᴜɴᴄᴛɪᴏɴ sɪᴍᴘʟʏ ʀᴇᴛᴜʀɴs ᴛʜᴇ ʀᴇsᴜʟᴛ ᴏғ ᴛʜᴇ ғᴏʀᴍᴜʟᴀ.

Answer 2

Answer:

Here's your solution

Explanation:

Error_value (required argument) – This is the error value for whom we wish to find the identifying number. Though error_val can be the actual error value, it will usually be a reference to a cell containing a formula that we want to test.