Changes

Jump to navigation Jump to search
Line 29: Line 29:  
*For e.g. "20" is normally converted as a number 20. But in ISNUMBER("20") will return FALSE, because "20" will not convert in to number.
 
*For e.g. "20" is normally converted as a number 20. But in ISNUMBER("20") will return FALSE, because "20" will not convert in to number.
   −
These are the nine worksheet functions used for testing the type of a value or reference.The function displays 1 or 0 depending on the outcome.
  −
  −
'''ISBLANK'''
  −
'''V'''
  −
'''ISERR'''
  −
'''V'''
  −
'''ISERROR'''
  −
'''V'''
  −
'''ISLOGICAL'''
  −
'''ISNA'''
  −
'''ISNONTEXT'''
  −
'''ISNUMBER'''
  −
'''ISREF'''
  −
'''ISTEXT'''
      
*ISBLANK  
 
*ISBLANK  
writer
5,435

edits

Navigation menu