Dec 27, 2008

Inserting tick symbols in a cell in Excel based on conditions











12

12

=IF(B13=C13,CHAR(254),CHAR(253))

13

13

=IF(B14=C14,CHAR(254),CHAR(253))

14

12

=IF(B15=C15,CHAR(254),CHAR(253))

251

=CHAR(B17)

252

=CHAR(B18)

253

=CHAR(B19)

254

=CHAR(B20)


Posted at 12:50 PM Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)