Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Arrow changing If statement
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to insert a special character (arrow) in IF statement | Excel Worksheet Functions | |||
Changing arrow color on the auto filter | Excel Discussion (Misc queries) | |||
why dont shift+arrow or ctrl+arrow work in 2007 | Excel Discussion (Misc queries) | |||
If Then statement for changing Values | Excel Worksheet Functions | |||
changing filter arrow colors | Excel Discussion (Misc queries) |