Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an error within my expression, any idea how to correct please?
if(match(Year = '2018' and Type = 'New'), '0.48',
if(match(Year = '2019' and Type = 'Used'), '0.33',
if(match(Year = '2018' and Type = 'New'), '0.52',
if(match(Year = '2019' and Type = 'Used'), '0.66'))))
Thanks
Why are you using match()? Match takes two parameters.
Try this:
if((Year = '2018' and Type = 'New'), '0.48',
if((Year = '2019' and Type = 'Used'), '0.33',
if((Year = '2018' and Type = 'New'), '0.52',
if((Year = '2019' and Type = 'Used'), '0.66')
)
)
)
Thanks for the suggestion but the logic doesn't appear to work. I'm not too sure what is meant by your latest comment, sorry?
Why are you using match()? Match takes two parameters.
Try this:
if((Year = '2018' and Type = 'New'), '0.48',
if((Year = '2019' and Type = 'Used'), '0.33',
if((Year = '2018' and Type = 'New'), '0.52',
if((Year = '2019' and Type = 'Used'), '0.66')
)
)
)