How do I type the up/down/no change arrow in a forumula?

[amc11]

I don't know what they are called otherwise I would look it up myself.


I'm trying to type on of chandoo's forumula. This is the link or picture:


http://photos1.blogger.com/photoInclude/blogger/5264/463/1600/dashboard%20formula.jpg


Please hurry. I want to type this formula badly.

 

[dan_l]

just get it off the car map, slap it into a named range, and reference the named range when you want it in a formula.


That's what the pros do.

And by pros, I mean me.

 

[amc11]

What? Where is the car map?

I'm a newbie, and this is the first time I've been to Chandoo's website (today).

 

[mr_hiboy]

Hi,


one simple way is too change the font to WEBDINGS and use the following

5=up

6=down

34= left and right


example formula =IF(A1<0,6,IF(A1>0,5,34))

So if A1 is less than 0 then down arrow, greater than 0 then up arrow, equal to 0 left and right.


Hope this helps

 

[dan_l]

Hiboys way works. I always get the arrows out of the character map. It's under accessories. Find the arrows you want, copy them out and put them in individual cells. So the "up" arrow will be in a cell you just named "UP". So your formula could be:


=if(a1>average(a:a),up,down)

 

[kishore_lp]

Dear amc11


Type Alt+798 for Up Arrow; Alt+799 for Down Arrow and Alt+784 & Alt+785 for No Change Arrow from ur numeric keypad

Hope this solves ur problem..