Can I use this in Google Sheets or WPS?

Yes. Use the Sheets or WPS version shown below. Adjust ranges to match your sheet.

Formula Library

Excel Formula To Calculate Percent Change Vs 14 Rows Ago In Crm Export Text

Paste the formula into the first output cell, then fill down to apply it to your range.

Calculate percent change versus 14 rows earlier in crm export text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Calculate percent change vs 14 rows ago in crm export text.

ExcelGoogle SheetsWPS

=IFERROR((A2-INDEX(A:A,ROW()-14))/INDEX(A:A,ROW()-14),0)

Calculate percent change versus 1 rows earlier in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Calculate percent change versus 2 rows earlier in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Calculate percent change versus 3 rows earlier in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Calculate percent change versus 7 rows earlier in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Calculate percent change versus 14 rows earlier in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Calculate percent change versus 30 rows earlier in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.