Arrow changing If statement

B

BBDavid1

I'm trying to write an if statement that is contingent upon a number being
positive or negative and the outcome of a positive number will show an
autoshape arrow to the right or a negative number will show an autoshape
arrow to the left.
 
F

FSt1

hi,
not sure if you can do it with autoshape but you can do it with symbles.
write your if formula like this.....
=if(A2>0,0,0)
yeah, i know. stupid looking but we're going to change it.
select the cell. don't lilke into the cell to edit.
on th menu bar.....insert>symble.
scroll down and find the up arrow. click insert. find the down arrow. click
insert.
on the formula bar the contents of the cell will look like this....
=IF(B2>0,0,0)▲▼
if you press enter at this point, excel will freak out.
click into the formula(edit mode) after the close parentheses.
back space out the two zero living this....
=IF(B2>0,▲▼
enclose the arrows in double quotes.
=IF(B2>0,"â–²","â–¼")
excel will diplay the arrows like a text character.
press enter.
done.

Regards
FSt1
 
Top