CONVERT is fully automatic and based on “from” and “to” unit strings.
As long as the units valid options in the same category (weight, distance, temperature, etc.
), CONVERT will automatically perform a conversion and return a numeric result.
Both the “C” and “F” must be uppercase.
If so, the original CONVERT formula is run.
Unit strings must be valid and in the proper case.This page shows available options in each category.
NOT Function
The Excel NOT function returns the opposite of a given logical or Boolean value.
When given TRUE, NOT returns FALSE.
When given FALSE, NOT returns TRUE.
Use the NOT function to reverse a logical value.
For example, if A1 contains “apple”, ISBLANK(A1) returns FALSE.
