Forum Discussion
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...
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
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"})Thank you both for your help. Much appreciated.
Logaraj Sekar
Faysal Al Farooqui