Wednesday, April 24, 2013

yogi_Setup ArrayFormulas For Computed Columns In A Transactions Sheet


                                          Google Spreadsheet   Post  #1150
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 24, 2013
user quinnrz :(http://productforums.google.com/forum/?zx=crpyw0e3sdva#!category-topic/docs/spreadsheets/kFP2bX2wcxg)
How Can I Apply a Function to multiple Rows
I am trying to duplicated the formula in multiple rows, please see the 2nd row where I have applied the formula to. My question is how to continue the function in other following rows?


---
Hi

a) I have applied the formula in F2 (item total in ¥) where the total is D2 (item total ¥) + E2 (fees ¥)
b) and G2 (total GBP) where it is F2/1.96
c) lastly I key in my selling price and I will apply the function to get the profit. 

The thing I want to achieve is to copy the functions I applied in 2nd row, so they can continue downwards where I only need to key in numbers in future, rather than repeating setting up the function again.

Hope I am clearer this way.
------------------------------------------------------------------------------------------------------------------------
following is a solution to the problem


No comments:

Post a Comment