Die Tipe ( ) funksie gee terug 1 as Die waarde is ' n nommer , 2 as dit is teks , 4 as Die waarde is ' n logiese waarde , 16 as dit is ' n fout waarde of 64 as Die waarde is ' n skikking . as Die sel Die waarde verteenwoordig bevat ' n formule jy kry sy terug Tipe .
The TYPE( ) function returns 1 if the value is a number , 2 if it is text , 4 if the value is a logical value , 16 if it is an error value or 64 if the value is an array . If the cell the value represents contains a formula you get its return type .