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.
|