what does ~ operator mean?

[Guest]

=IF(C20="","",IF(C20="~Select","",LOOKUP(C20,$P$2:$P$30,$Q$2:$Q$30)))

Hi, what does the "~" operator do in this formula? Is it saying "if not
selected?"


Thank you,

Todd

 

[Dave Peterson]

In that formula, it's really looking for that tilde character in C20. Just like
any other character.

 

[Guest]

Thanks, a further question?

Cell C20 has a drop down list to select from. None of the selections have
the tilde and the formula calculates when any of the selections are chosen
and returns "" if none are. I am trying to figure out how this works, so I
can use it myself later.

Here are the selections to chose from.
a 7500
b 7520
c 7533
d 1708
e 1808


Thanks again,

Todd

 

[Guest]

ok, I understand now. Its and added part of the formula no longer used but
not taken out.

Thank you so much!