Hi..I am working on a sheet which has a column with the usual RAG status but now I need to introduce a new status of "NA" and replace a sizeable number of records (c. 6k+) with this new status based on a pre-defined value from another column. I was wondering if there was a quicker way of doing this using the "If" formula but could not figure out what should I put in the else section because the remaining records should continue to reflect the current status of R, A or G.
I am using excel 2010
How are R/A/G assigned currently?
If they're filled in by a formula you just need to update the formula; if they're manually entered or otherwise imported fields, you're going to have to either use a macro to replace them with N/A or pump them into a helper column.
Hi and welcome to the forum
No idea what RAG means, but it would probably help if you uploaded a sample of what you have and what you want
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
Red/Amber/GreenOriginally Posted by FDibbins
Three-color-code traffic light for "Bad"/"Warning"/"Good"
...I assume. It could be something else...?
given the minimal info, here is a minimal info answer.
=IF(A2<5,"R",IF(A2<10,"A",IF(A2<20,"G","NA"))) and the #s I used are obviously arbitrary. But maybe this can be a basis for what you want?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks