formula to define the number of gallons used

C

CindyAnn

I need to separate three chemicals and break down the totals of each on one
spread sheet. I need direction on how to create formula's to handle the
thousands of gallons my organization uses of each! I just started this job
and wish to impress the boss please help!
 
O

Otto Moehrbach

Cindy
You have to give us more info. For instance, what is the layout of your
data? That is, what's in Column A? Column B?, etc? Now, obviously, you
want these formulas to give you some information. What information? Where
do you want this information and what do you want it to look like? It would
help if you told us, in detail, exactly what you would do if you had to do
this manually, without formulas. HTH Otto
 
C

CindyAnn

Hi Otto,

I am in the process today of creating the spread sheet. We can assume
Column A will have three cells with a formula to calculate the percentage of
the three chemicals per gallon. In row A, cell one, I will input the number
of gallons, I need cells 3,6 and 9 to populate automatically with the number
of gallons used for the chemical used based on the percentage within that
formula. Thank you for your responce! ~CindyAnn
 
C

CindyAnn

Hi Joel,
I have searched the templates and have not found what I need. If you know
of one that will assist me, will you post the name?
Thanks ~CindyAnn
 
Top