Are there any Metastock users in here?

I've got a formula in Metastock that I want to use in Excel but Metastock uses a function called PREV which I can't replicate in Excel so looking for some help.

Thanks.