I want to show (down arrow) if value in a cell is negative number and show (up arrow) if value is positive number . I tried this formula [=IF(I2=TRUE(),”p”,”q”)] and used font type wingding3, but it works only for negative value not changing when value is positive number. Any help is highly appreciated.
Assigning symbol to positive/negative numbers in a cell(8 posts) (5 voices)
I assume your value is in the cell I2.
change the formula to
=if( I2>=0, "p", "q")
With 2007+ : Select your cells, then click on then Conditionnal "Formating button" in "Style group" / "Icon Set".
You'll see there 3 arrows "up green", "even yellow", and "down red". Select it.
Then Click on "modify rules" and adapt the rule created for your range. Put even to 0.
Thanks for quick response, but the value in I2 is the result from a formula [=C15-SUM(F15:F20)] so it can change to either negative or positive as the values in the dependant cells changes. Hope it makes sense to you and everyone else.
Then change font to Wingding3
Thanks a lot, works perfect, great help as usual.
Just a thought, if the figure was neither positive or negative i.e. zero then you could use
And Don't forget you can use conditional formatting to change the colors of the Negative (Red) and Positive (Green/Black) Arrows
Like the examples here
The report generated from our co. software in excel have negative figures suffixed as "-" for ex.
How should i Bring the negative sign for this type of data as prefix when there is huge data and also in a columnar manner.
Hello If any one on you know how can easily use the if condition complete method how to use and for which purpose it can be utilized?
You must log in to post.