Qmem and icons

[guillaume_gorli]

Hi all,

I need to show graphically the results of a formula :

If the results is greater than 0.90 AND smaller than 1.10 then the smiley should be green, otherwise it has to turn red.

I am struggling to have both conditions taken into account. This is working as long as i have one sole condition to apply :

=if(formulas) > '0.90' , 'qmem://<bundled>/BuiltIn/smiley1_g.png','qmem://<bundled>/BuiltIn/smiley3_r.png')

Could someone advise how to write such scenario ?

Thanks

Guillaume

[guillaume_gorli · Accepted solution]

Found it myself :

For those who may need it :

=if(

(formulas) > '0.90'

and

(formulas) < '1.10')

,

'qmem://<bundled>/BuiltIn/smiley1_g.png','qmem://<bundled>/BuiltIn/smiley3_r.png')