Reply To: Some important formulas in excel

[Arpit SuranaParticipant]

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 app

This 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.