Select Constants and formulas:
Welcome to the second post of this series – Select constants and formulas. Click here to read to navigate to go to special and also to select comments.
What are constants and formulas?
Well, constants are values that are unchanging in nature. They are not dependent on any other constant or variable.
Formulas on the other hand are derived based on the value of referred cells. Formulae copied and pasted as values are constants as well for selectionJ. Having said that, let’s explore the options to select constants and formulas by using “Go to special”.
Data types of constants and formulas can be number, text, logical and error.
Number can be any numeric value
Text can be any text (string) value.
Logicals are TRUE and FALSE.
Errors are all the error types in excel. #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!.
Tip: If you select a range and then go to special and select your criteria, it selects the criteria only from your selected range.
