CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-sheets-api
user8612252
user8612252

Reputation:

Blank value in Google sheet

I want to calculate the quotient of the cells in E and D rows, the logic is if both cells contains valid values then calculate otherwise do not do anything.

So far this is my formula:

={"OR (Open Rate)";ARRAYFORMULA(IFERROR(E2:E/D2:D))}

This works fine as it doesn't add value to the cell. But when I use the getLastRow() function on script editor, I get almost the 1000th cell on my empty sheet.

I suspect that the formula I am using is inserting a space or falsey values on each cell. How can I leave the cell blank if it doesn't meet my logic expression?

Upvotes: 0

Views: 1102

Answers (1)

TheMaster
TheMaster

Reputation: 50472

={"OR (Open Rate)";ARRAYFORMULA(IFERROR(E2:INDEX(E2:E,COUNTA(E2:E))/D2:INDEX(D2:D,COUNTA(E2:E))))}

Upvotes: 1

Related Questions