This formula placed in data validation will only accept values greater than the cell above it: =A1>A2 True False
Question
This formula placed in data validation will only accept values greater than the cell above it: =A1>A2 True False
Solution
False. The formula =A1>A2 will not only accept values greater than the cell above it. This formula is comparing if the value in cell A1 is greater than the value in cell A2. If you want to accept only values greater than the cell above, you should use the formula =A2>A1. This formula checks if the value in cell A2 is greater than the value in cell A1, which is the cell above A2.
Similar Questions
Data validation does not have to stop data from being entered in a cell, it can also warn you with a user identified message. True False
When using the Data Validation function of Excel, you must ensure that you do what?Select a maximum of four cellsSelect one or more cellsSave your work before you start the process
The output of a data validation statement in a customized formula can change just the font and not the color of a cell to indicate that it has been validated True False
"What MS Excel feature restricts entries in a sheet, such as a date range or whole numbers only?"Conditional formattingSummationData validationData sort
This formula in data validation only accepts Tuesday as the day of the week: =weekday(A1)=2 True False
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.