View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Ascribing Values to Symbols

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.
--
Gary's Student


"Chet" wrote:

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.