Sharepoint calculated column help- absolute values?

Hi, I want to create a calculated value in my SharePoint list, based on 2 other columns; in a previous excel document I have used: =IF([@[Response On Time]]=$AV$2,"On Target",IF([@[Revised Respons...

Lists

Norman Young
Dec 06, 2019
Hi carmelowen2105,

Can I not just change the absolute value reference ($AV$2) to a Yes/No as specified in the columns i'm using- why won't that work?

Yes you can.

Here is an example that I used recently:
=IF(Priority="Low",Created+7,IF(Priority="Medium",Created+14,IF(Priority="High",Created+21,Created)))

I reference this site whenever I am creating calculated columns - https://support.office.com/en-us/article/Examples-of-common-formulas-in-SharePoint-Lists-D81F5F21-2B4E-45CE-B170-BF7EBF6988B3

I hope this helps.

Norm