IF and AND Statement

[thomas_2583]

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

[jonathandienst]

I think you mean 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')))

[jonathandienst]

Sorry the format options are missing and the white spaces are being ignored

[thomas_2583]

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?

[Vegar · Accepted solution]

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')
    )
  )
)