Tick and cross symbols in same cell based on formula

[sobrien1234]

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]

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

Book1
	A	B
1	1	r
Sheet1

Cell Formulas
Range	Formula
B1	=IF(A1=0,"a",IF(A1>0,"r",""))

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.

Book1
	A	B
1	1	r
Sheet1

Cell Formulas
Range	Formula
B1	=IF(A1=0,"a","r")

 

[sobrien1234]

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

	A	B

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]r[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B1[/TH]
[TD="align: left"]=IF(A1=0,"a",IF(A1>0,"r",""))
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



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.

	A	B

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]r[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B1[/TH]
[TD="align: left"]=IF(A1=0,"a","r")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Thanks that works !!

 

[MARK858]

You're welcome.

 

[MARK858]

For me...