Ascribing Values to Symbols

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find and replace with a tick 1
Using Symbols in Drop Down Lists 2
vba macro that allows insertion of symbols at cursor 0
Extract Symbol 9
countif symbols 3
Greater Than Symbols and calculations 0
Calculation / Format Error 1
VBA to select font/colour not working 1

Back
Top