Subscribe
Hello all,
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)-
Posted 2 years ago #
-
Hello
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.Posted 2 years ago # -
cyrilz,
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.Posted 2 years ago # -
Razaas
Try=IF(I2<0,"q",IF(I2>0,"p",0))Then change font to Wingding3
Posted 2 years ago # -
And Don't forget you can use conditional formatting to change the colors of the Negative (Red) and Positive (Green/Black) Arrows
Posted 2 years ago # -
Yeh,
Like the examples here
http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/
Posted 2 years ago # -
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.Posted 2 years ago # -
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?
Posted 2 years ago #
Reply
You must log in to post.
Welcome to Chandoo.org. New here?
Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.
