Google Spreadsheet Post #929
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Dec 18, 2012
user David Funes said:(https://productforums.google.com/forum/#!mydiscussions/docs/-Q9BVHn3mE0)
user David Funes said:(https://productforums.google.com/forum/#!mydiscussions/docs/-Q9BVHn3mE0)
Forms-Preset Calculations
I am trying to create a form that will drop static figures into a spreasheet that will use that information to do calculations (like a price markup).
I am noticing that whenever I make an entry on the form, however, it pushes down the entire row down one, instead of populating the available fields in the given row.
Is there a way for me to use forms to drop in a static figure and continue to do calculations in the same row, without moving all my equations down a whole row with each entry?
---
Here is a sample of what I am working on:
I had looked at the array formulas, and they look like what I need, altho I don't see an option for dividing figures using the array, is there a way I can use inverse and multiplication? Or is there simply an option for division that I may have missed.
Also, I am still noticing that when I submit a response from the form, the existing row still moves down,In the given example columns A,B, and C are populated by the form, and columns D,E,F consist of a static figure, the product of C and D, and a fraction of E (respectively).
The goal is to create a form that will drop all the information i need into a single sheet, and have the formulas create the markups and discounts i need.
Would it be better to use multiple sheets?
-------------------------------------------------------------------------------------------------------------
following is a solution for a bit more generalized problem
No comments:
Post a Comment