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