charts calculations

[prabhas277]

Hi experts,

is it possible multiple conditions in one if conduction?

ex: I have one bar chart in that layout tab i will write if(product='apple',1,0) it means product=apple then the chart will visible now my question is if(product='apple''banana',1,0) is it possible?

[Kushal_Chawda]

yes, try this

=if(match(lower(Product),'apple','banana'),1,0)

[maxgro]

=wildmatch(product, 'apple', 'banana')

[MarcoWedel]

if(product='apple' or product='banana',1,0)

hope this helps

regards

Marco

[MarcoWedel]

or simply

product='apple' or product='banana'

regards

Marco

[MarcoWedel]

or

=mixmatch(product, 'apple', 'banana')