Forum Discussion

Martin Chilvers's avatar
Martin Chilvers
Copper Contributor
Jun 03, 2017

Displaying text based upon results

Hello All,   New to this group, and still finding my way around excel.   I want to link 4 text boxes to one cell result. Each text box will explain differing results (i.e. one text box for result...
excel
Martin Chilvers's avatar
Martin Chilvers
Copper Contributor
Jun 04, 2017

Logaraj Sekar
I'm very new to this. Are you able to show an example for me.

For example, one cell of a table is going to have a value btween -50 and 50.

On the dashboard, if the value is between -50 and -16 I want it to say Extreme Slow Oxidiser.

If the value is between -16 and -5, moderate slow oxidiser
If the value between -5 and 0, mild slow oxidiser
If the value between 0 and 5, mild fast oxidiser
if the value between 5 and 16 moderate fast oxidiser
and if the value between 16 and 50, extreme fast oxidiser.

Thank you for your time and effory in advance.

Martyn


Logaraj Sekar's avatar
Logaraj Sekar
Iron Contributor
Jun 05, 2017

Hi Martin Chilvers

 

You specified value between -50 and -16 as "Ext. Slo. Oxid" . (This means you want results for value -49 to -15 and it not includes -50 & -16. Because you specified it as between).

 

You also specified for the following values like -16 and -5 (This also never includes -16 and -5. It took only -15 to -4).

 

So if you i taken you condition of "between -50 and -16" as "greater than or equal to -50 and less than or equal to -16". If your cell has value of "-16", this will result "Ext. Slo. Oxid" only.

 

So i modified Faysal Al Farooqui formula, as per i told. Try this if it solves.

 

=LOOKUP(A1,{-50,-15,-4,1,6,17},{"Extreme Slow Oxidiser","Moderate Slow Oxidiser","Mild Slow Oxidiser","Mild Fast Oxidiser","Moderate Fast Oxidiser","Extreme Fast Oxidiser"})

Resources