I want to create the labels of "green","yellow", or "red" depending on the value found in a certain cell.
-5000 -> 0 & 0 -> 5000 are green
-50000 -> -5000 & 5000 ->50000 are yellow
anything lower than -50000 & anything higher than 50000 is red
the current formula I have is this :
=IF(I9<"-50000","red",IF(I9>="-50000","yellow",IF(I9>"-15000",IF(I9<=15000,"green",IF(I9<=50000,"yellow",IF(I9>50000,"red"))))))
I keep getting everything as red whenever I include the negative numbers. Please help!
Don't surround numbers, even when they are negative, with quotes.
I wonder if this might work for you...
=IF(ABS(I9)<=5000,"green",IF(ABS(I9)<=50000,"yellow","red"))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
That did work a bit, but then green never appears.
which post are you referring to?
You are amazing! Thanks!
maybe this?
=IF(ABS(I9)>50000,"red",IF(ABS(I9)>5000,"yellow","green"))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry, you were right. Thanks!Originally Posted by Sambo kid
If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks