Some important formulas in excel
- This topic is empty.
-
Posts
-
shreyanshh
ISNUMBER(VALUES) – returns TRUE if the value is a number, otherwise FALSE Similarly there are few other formulas also such as – 1) ISURL(VALUES) – to check if the selected values are URL
2) ISFORMULA(VALUES) – to check if the selected values is a formula
3) ISTEXT(VALUES)- to check if the selected values is a text
These functions return TRUE /FALSE based on the data.
Sent from my S6s using
Actuarial Info mobile appArpit Surana
shreyanshh wrote:ISNUMBER(VALUES) – returns TRUE if the value is a number, otherwise FALSE
Similarly there are few other formulas also such as – 1) ISURL(VALUES) – to check if the selected values are URL
2) ISFORMULA(VALUES) – to check if the selected values is a formula
3) ISTEXT(VALUES)- to check if the selected values is a text
These functions return TRUE /FALSE based on the data.
Sent from my S6s using
Actuarial Info mobile appThis function is really helpful,
You can also use Conditional formating also, its also really helpful function. It can be used to find empty cells, incorrect values, highlight the imp things and lot of things.
If anyone wants i can write a post on how it is used and what’s the importance of it.
Mayank Goyal- You must be logged in to reply to this topic.