Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to figure out how many gallons sold at what price and what the total
dollor amount is for gallons total under a set price.

I have some experiance with formulas but I think this one I need help with.

Example:
Gallons|Price|Total Gallons|Total Gallon Price|
a2 b2 c3 d4
100 1.899 350 664.65
150
100
 
Hello PCServices

If these contain the following values
A2 10
A3 15
A4 10
B2 1.89

These cells will contain the following formulas
C3 =SUM(A2:A4
D4 =C4*B

Sincerely
Leith Ros
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top