Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
Hello PCServices, If these contain the following values: A2 100 A3 150 A4 100 B2 1.899 These cells will contain the following formulas: C3 =SUM(A2:A4) D4 =C4*B2 Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=512051 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not recognizing new data | Excel Discussion (Misc queries) | |||
Countif formulas change after doing a sort | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |