LibreOffice Calc formula to identify last four digit of a cell which even or odd

I am using LibreOffice version 4.x to 6.x Ubuntu 14.04, 16.04. There is data in the format Category/Number/Year. I need a formula which will identify whether the year is even or odd and then will writer a specific value for even number and a different value for odd number. I know I can extract data by text to column feature but I want to know how can we achieve with formula.

1 Like

=IF(ISODD(VALUE(RIGHT(A1;1)));"Odd";"Even")?

2 Likes

Thanks it works