# Tick and cross symbols in same cell based on formula

#### sobrien1234

##### Board Regular
In cell A1 I have a formula which comes up with either 0 or a number greater than 0.

In cell B1 I want:
1. A tick symbol to appear if A1=0
2. A cross symbol to appear if A1 >0

Not sure how to do it or what formual would allow this as I have never dealt with symbols in formulas?

Can this be done?

#### MARK858

##### Well-known Member
Try using the formula below and change the font in B1 to Marlett.

If a minus number really isn't a possibility then you can just use the formula below and again change the font in B1 to Marlett.

Last edited:

#### sobrien1234

##### Board Regular
Try using the formula below and change the font in B1 to Marlett.

AB
11r

</tbody>
Sheet1

Worksheet Formulas
CellFormula
B1=IF(A1=0,"a",IF(A1>0,"r",""))

</tbody>

<tbody>
</tbody>

If a minus number really isn't a possibility then you can just use the formula below and again change the font in B1 to Marlett.

AB
11r

</tbody>
Sheet1

Worksheet Formulas
CellFormula
B1=IF(A1=0,"a","r")

</tbody>

<tbody>
</tbody>
Thanks that works !!

You're welcome.

For me...

Last edited: