# If/Then Statement with Year

Hello there!

I am brand new to Airtable formulas and was hoping to get some help. I’m attempting to calculate NPS just for this calendar year of 2022. I was able to calculate the NPS for all of my results but when I try to modify it to add in just for the year 2022 as an If/Then statement it doesn’t work. Here is what I have been attempting to use. Thank you so much for your help!

IF(

Date}=2022

)

THEN(

{NPS Score}=BLANK(),BLANK(),

IF({NPS Score} < 7,-100,

IF({NPS Score} > 8,100,

0)))

THEN() is not a function in Airtable. IF()s look like this

``````IF(
condition,
value if true,
value if false
)
``````

``````IF(
{Date} = 2022,
IF(
{NPS Score} = BLANK(),
BLANK(),
IF(
{NPS Score} < 7,
-100,
IF(
{NPS Score} > 8,
100,
0
)
)
)
)
``````

If {Date} is a full date instead of just a year then your formula should instead include `YEAR({Date}) = 2022`

1 Like

Thank you SO much!!! It worked!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.