NOT UNDERSTANDING THE FORMULA

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

Guest

SORRY = here is the problem clearly stated:
A: filling in a Order Sheet
1. coloum a2,3,4,5 will be the Quanities of each item
2. column g2,3,4,5 will be the unit prices of each item
3. column h2 will consist of the result of a2*g2
thus this formula would repeat itself throughout column "H" this if

A2 is 5 chairs
G2 is $10.00 each
H2 would be $50.00
"eXAMPLE" H14 would be the totals of coloums h2-h13 would be Place in h14

thus this is your standard odering form:
 
I've read your info that states col. A has the number of items, col. G
has unit prices and col. H is the multiple of A and G to yield total $
for each row. Then you SUM col. H to calculate the total $ involved.
You have presented the facts, so what is the question? GeorgeF
 

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

Similar Threads

CountIf with And 0
Date Formula 85 factor 7
Excel A CountIF question... I think 2
Formula Help 3
Copying formulas - problem with the sum 1
SUM formula (sort of) 1
Help to to create a Formula or Macro 3
Excel Formula Error 15

Back
Top