| T O P I C R E V I E W |
| caicaifish |
Posted - 10/15/2006 : 6:58:38 PM
Origin Version (Select Help-->About Origin): 7.0
Operating System:Windows XP
Is there a symbol for blank cell? when I do logic calculation, if the result is No, I wish the origin can return a blank cell!
Best wishes |
| 2 L A T E S T R E P L I E S (Newest First) |
| Laurie |
Posted - 10/19/2006 : 5:53:20 PM
If this were the Origin C forum, then NANUM would be the complete answer; however, since this is the Origin forum and you might be writing a logic calculation from the Extract Worksheet dialog or from Labtalk script then let me elaborate.
Using NANUM from LabTalk works because NANUM is not a defined variable. Not defined or assigned a value means when used it will automatically return a 'missing value'. Using NANUM will then work in your logic statement as long as you don't assign it some value. You could then use any variable that hasn't been defined. I could say the following:
if(col(B)[1] == cow) type -b "The value is missing!";
As long as I haven't previously assigned cow some value then an attention dialog will open saying "The value is missing!".
To check for a missing value you could also use 0/0.
if(col(B)[1] == 0/0) type -b "The value is missing!";
You can also use 0/0 to assign a missing value to any cell. For example:
col(B)[2]=0/0;
OriginLab Technical Support |
| zachary_origin |
Posted - 10/15/2006 : 9:35:45 PM
It is NANUM, which represents a missing value.
Zachary
OriginLab Technical Services.
Edited by - zachary_origin on 10/16/2006 12:38:04 AM |
