ExcelBanter - Arrow changing If statement

hi,
not sure if you can do it with autoshape but you can do it with symbles.
write your if formula like this.....
=if(A20,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.....insertsymble.
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(B20,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(B20,–²–¼
enclose the arrows in double quotes.
=IF(B20,"–²","–¼")
excel will diplay the arrows like a text character.
press enter.
done.

Regards
FSt1

"BBDavid1" wrote:

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.