Forum Discussion
Displaying text based upon results
Hi Martin Chilvers,
Combine them using CONCATENATE formula.
If this is not answer to your expectation. Put Screenshot to solve easily.
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
Assume that your A2 cell contains the value you want to measure with list. Use the below formula in B2 cell and press Enter:
=LOOKUP(A2,{-50,-16,-5,0,5,16},{"Extreme Slow Oxidiser","Moderate Slow Oxidiser","Mild Slow Oxidiser","Mild Fast Oxidiser","Moderate Fast Oxidiser","Extreme Fast Oxidiser"})Now if you enter the value in A2 cell like -8 then the formula will return the result "Moderate Slow Oxidiser" in B2 cell like below:
