UNICHAR code

[gtd526]

=IF(Q15>O15,UNICHAR(128314),UNICHAR(128315)),IF(Q15=O15,UNICHAR(61)) or
=IF(Q15>O15,UNICHAR(128314)),IF(Q15<O15,UNICHAR(128315)),IF(Q15=O15,UNICHAR(61))<o15,unichar(128315)),if(q15=o15,unichar(61))<o15,unichar(128315)),if(q15=o15,unichar(61))

I've tried these formulas for UNICHAR symbol depending on greater than, less than or equal to, but it doesn't work?????
I receive #VALUE !

Thank you!</o15,unichar(128315)),if(q15=o15,unichar(61))<o15,unichar(128315)),if(q15=o15,unichar(61))

 

[Joe4]

Welcome to the Board!

Note that you have not properly nested you IF formula. Your first one has both a TRUE and FALSE part right after it, so it would close/stop there:

=IF(Q15>O15,UNICHAR(128314),UNICHAR(128315))

If you want it "nested", you need another IF in either the TRUE of FALSE clause of this FIRST IF statement. Otherwise, it stops after the FALSE piece in your formula.

Also I see that you are having issues posting your formula. See this link here for the issue and resolution: https://www.mrexcel.com/forum/about-board/680917-formulas-not-appearing-completely-read.html

It might be best if you just describe your issue in plain English, telling us how it SHOULD work, and we can help you write it.

 

[Fluff]

Hi & welcome to MrExcel.
How about
=IF(Q15>O15,UNICHAR(128314),IF(Q15< O15,UNICHAR(128315),IF(Q15=O15,UNICHAR(61))))

 

[gtd526]

Yes, it works. Thanks.

 

[Fluff]

You're welcome & thanks for the feedback