what does ~ operator mean?

T

Todd

=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
 
D

Dave Peterson

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

Todd

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
 
T

Todd

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

Thank you so much!
 
Top