Google Sheets Divide Results of the Import Range-CodePudding

Home > database > Google Sheets Divide Results of the Import Range

Google Sheets Divide Results of the Import Range

Time：12-27

I have this GoogleSheets,

With a import range query : =IMPORTRANGE("1Z76YA8","'Sales'!1:1")

Is it possible to divide the results of my import range with "row 1 (currency euro) "?

CodePudding user response：

=ARRAYFORMULA(IMPORTRANGE("1Z76YA8","'Sales'!1:1")/B1:1)

If you do not want to output when row 1 is blank:

=ARRAYFORMULA(IF(B1:B="",,IMPORTRANGE("1Z76YA8","'Sales'!1:1")/B1:1))