Google Spreadsheet Post #1594
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr-09-2014
post by Benjamin Rojo: (https://productforums.google.com/forum/#!mydiscussions/docs/UWIykq-MGA8)
How to add a formula to ImportRange?
Hello All,
I would like to multiplicate the result of an "Importrange" formula directly in the receiving cell:
=importrange("
will give me the correct result only in the first cell of the column.
Without "*1.15", all the column is populated as it should.
Thanks in advance for your replys!
---
Thanks for your answer Yogi,
Test-Cigar-Cost
Test Cigar Price
I would like to increase automatically the prices in "Cost" of 15% with a result in "Price" column B.
(Price)B2=importrange("
If I have to repeat the process and change formulas in each cells I better make a Copy/Paste from Excel directly...which is time consuming.
(Price)B2=importrange("
My expected result is in (Price)ColumnC. I need those result without having to change manually the name of the base cell.
Thanks again
------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment