answersLogoWhite

0

When using the Validation facility you can set an Input message to tell the user what they should enter like "Enter a value between 1 and 100". You can set an Error message to show if they do not enter a value that is valid.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

Can you troubleshoot in excel?

Depends on what you mean by troubleshoot. Excel does have several auditing functions and error messages.


To what does a REF error message refer?

A REF error message is a message that is used in the Windows Excel program, part of the Office package, in that there is an error input or output in an excel cell data pack.


What are examples of error messages in Excel?

#NAME! #REF! #DIV/0! #N/A! #NUM! #VALUE!


Why are the validation error messages important on Microsoft Excel?

They tell the user that they have entered incorrect data and should tell them what they have done wrong and what is acceptable. Without the messages, the user will not know what the problem is.


Where is the formula error button in Excel 2007?

There is no formula error button in Excel. However, there is an Error Checking button on the Formulas ribbon in the Formula Auditing section in Excel 2007.


How do you enter characters containing in an Excel Cell without getting bothered by its error messages?

Enter valid characters or unprotect the cell. If you ask another question to identify the exact error message, you probably will get a more useful answer.


What is standard input and output error file?

The C standard library provides stderr as the standard error file. It is an output file, much like stdout, except it cannot be redirected via the command line. By default, error messages via stderr are output to the console, the same as the undirected stdout. However, the programmer may choose to redirect stderr to a disk file or allow the user to choose a location via command line switches. Although error messages can also be output to stdout (or indeed to any output stream), it is best to keep error messages separate from the standard output stream. For instance, the user may choose to redirect standard output to a disk file or to the input stream of another program, while error messages are directed to the console.


How do you input the marginal product equation in excel?

how do you find marginal product on excel


Will display to indicate a cell contains an error or message?

Common ways to indicate that a cell contains an error or message in Excel are through error indicators (green triangle in the top left corner of the cell), error messages, or custom formatting (e.g., changing the cell color or font style). You can also use conditional formatting to highlight cells with errors or messages.


What is Cell for excel?

the box into which you input data


If Excel cannot properly perform a calculation will it display an error value in the cell where you entered the formula?

That will depend on what the error is. Different problems result in a formula not being able to calculate. The appropriate error message for the situation will be displayed. Here are error messages you will see: #REF! #DIV/0! #NAME? #NULL! #N/A! #NUM! #VALUE!


What is ICMP used for?

to send error messages to send control messages