Ascribing Values to Symbols

C

Chet

Hi there,

Am seeking assistance. How would I go about ascribing a value to a symbol in
Excel? For example if I wished to use ticks and crosses from WingDings and
have them represent a 1 and Zero value respectively so that they could be
used with basic formulas.

Any help would be greatly appreciated. Many thanks.
 
G

Gary''s Student

You can ascribe the value in the referencing statement:

=IF(A1=CHAR(252),1,0) where A1 would be formatted as Wingdings and
CHAR(252) is the check-mark.
 
Top