| Author |
 Topic  |
|
|
dominik.mierzwa
Poland
128 Posts |
 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 |
|
|
Shirley_GZ
China
Posts |
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 |
 |
|
|
dominik.mierzwa
Poland
128 Posts |
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 |
|
|
| |
Topic |
|
|
|
OR for IF function