In your day to day activities, start using IF command to get a desired response from number
Syntax
If( Condition, Action if True, Action if false)
Ex: I have a series of line itesm with slno in Column’B’, I want to know if there is any record missing. So I write this command in column ‘c’
=IF(B9=B8+1,"","Record Missing: "&B9-1)
Input function
Output
There could be multiple scenarios that you could use…
No comments:
Post a Comment