You are here: Features > Cell Functions > Miscellaneous Functions > ISINGRP function

ISINGRP Function

The ISINGRP function indicates whether a map number is contained within a calculated map number. It returns a value of 1 if the map number is contained within the calculated map number and 0 otherwise.

Syntax

ISINGRP("Group", "Source", "Destination")

Where

Group represents the map or group number.

"M" = map
"1" = Group1
"2" = Group2, and so on
"0" = Group10

Source represents the group or map string to find in the destination group or map string.

Destination represents the group or map string in which to look for the source group or map string.

Example 1

Map 500 is a calculated map number that sums up the map numbers, 100, 101, and 102.

ISINGRP("M", "101", "500")

Returns 1, since map number 101 is contained within calculated map 500.

Example 2

Map 500 is a calculated map number that sums up the map numbers, 100, 101, and 102.

ISINGRP("M", "103", "500")

Returns 0, since map number 101 is not contained within calculated map 500.

Related Topics