# Replace elevation value

suzuki
Global Mapper UserPosts:

**6**
hi,

how can i do elevation value from -3 to +3 , reassign to Zero

the value between -3 ~ +3 will output as zero

the formula follow didn't work

FORMULA=if(-3<B1<3,0,B1)

i need the correct GM Script language sample

thanks

Best Regard.

suzuki

how can i do elevation value from -3 to +3 , reassign to Zero

the value between -3 ~ +3 will output as zero

the formula follow didn't work

FORMULA=if(-3<B1<3,0,B1)

i need the correct GM Script language sample

thanks

Best Regard.

suzuki

Tagged:

## Answers

6that's really great solution!!

thanks a lot ,

265Trusted UserYou can also accomplish the same thing using the formula:

if( elevation < 3 and elevation > -3. 0, elevation ), or equivalently,if ( elevation < 3 & elevation > -3, 0, elevation )Cheers,

~Jeff

265Trusted UserModifying the grammar to handle this type of construct could probably be done, but it's a little tricky, and then it also wouldn't work in the same way that Excel formulas do.

Best regards,

~Jeff