<div>
Hi,<br />
<br />
pls try<br />

<pre><code class="code-1 nolinks" id="code-20-42399426-1"><span>=INDEX({&quot;Blue&quot;;&quot;Green&quot;;&quot;Red&quot;},MATCH(A1,{&quot;b&quot;;&quot;g&quot;;&quot;r&quot;},0))</span>
</code></pre>
Regards
</div>


<div>
<div class="content wysiwyg-content">
I have an excel spread sheet that has a column with either b, g or r<br />
I would like to create a formula in a separate column which will convert this to either Blue, Green or red<br />
<br />
Gordon
</div>
</div>


I have an excel spread sheet that has a column with either b, g or r
I would like to create a formula in a separate column which will convert this to either Blue, Green or red

Gordon

How to create a formula

R is a programming language and environment used primarily for statistical data analysis.

Statistical packages are software titles, such as JMP and GNU Octave, and programming languages, such as MATLAB, R and SAS, that are used to discover, explore and analyze data and suggest useful conclusions, either to learn something unexpected or to confirm a hypothesis. The field includes the design and analysis of techniques to give approximate but accurate solutions to hard problems in statistics, econometrics, time-series, optimization and 2D- and 3D-visualization. Data analysis has multiple facets and approaches, encompassing diverse techniques under a variety of names, in different business, science, and social science domains.