Hi
I have managed to get up and down arrows to show increases and decreases to the variances in specific populations, please see attached. I would like to remove the minus "-" sign on the decreases. I would also like to make the arrows bigger and bolder.
Thank you
Regards
Cortlyn
Last edited by Cortlyn; 05-14-2013 at 04:37 PM.
This will remove your negatives
=IF(B2>0," ↑ ",IF(B2<0," ↓ ", " ↔ "))& TEXT(ABS(B2), "0.00%")
I also put some spaces in front of and behind your arrows to separate them a bit so they stand out. I do not have any idea how to bold only them or make only them larger.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
That is a great help ChemistB. Thank you very much..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks