| T O P I C R E V I E W |
| dominik.mierzwa |
Posted - 11/24/2022 : 03:08:00 AM
Origin Ver. and Service Release (Select Help-->About Origin): 2022
Operating System: W10
Hi,
Please forgive me for asking a stupid question. I used it but I forgot how to compare two conditionals in IF function.
if(B$=="V*"|"r*", (A-B)/(A-C),-)
I used | as OR but it does not work. Values in Col(B) are string type data.
Kind regards,
Dominik |
| 2 L A T E S T R E P L I E S (Newest First) |
| dominik.mierzwa |
Posted - 11/24/2022 : 04:45:50 AM
quote:
Originally posted by Shirley_GZ
Hi Dominik,
Please try the formula below:
if(B$ =="V*"||B$ == "r*", (A-B)/(A-C),0/0)
Thanks,
Shirley
Hi Shirley,
I am really embarrassed  Thank you it works.
Kind regards,
Dominik |
| Shirley_GZ |
Posted - 11/24/2022 : 04:20:53 AM
Hi Dominik,
Please try the formula below:
if(B$ =="V*"||B$ == "r*", (A-B)/(A-C),0/0)
Here, I suppose the false_value is missing value.
Thanks,
Shirley
Originlab Technical Service Team |
|
|
