if and date function

Vasanth Balakrishnan

Hello,

if a cell has the year 2024, perform this operation (98.17 *3), and if a cell has the year 2023 perform this operation (95.17*3).

this is the formula i'm using its showing error - =IF(RTS@row, (YEAR(@cell) = 2024), (98.17 * 3), if(RTS@row, (YEAR(@cell) = 2023), (95.17 * 3)))

RTS@row is a date column

DKazatsky2

Hi @Vasanth Balakrishnan,

Your formula should look like this.

=IF(YEAR(RTS@row) = 2024, (98.17 * 3), IF(YEAR(RTS@row) = 2023, (95.17 * 3)))

The @cell reference will only work inside of a range, this is a single cell.

Hope this helps.

Dave

DKazatsky2

Hi @Vasanth Balakrishnan,

Your formula should look like this.

=IF(YEAR(RTS@row) = 2024, (98.17 * 3), IF(YEAR(RTS@row) = 2023, (95.17 * 3)))

The @cell reference will only work inside of a range, this is a single cell.

Hope this helps.

Dave

Vasanth Balakrishnan

This works, thanks