Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Hi there, I'm new here so I don't know if this kind of a question was here before ;) Here's the problem: On a worksheet I have two columns with about 100 or even more rows and in every filed there is a number (i.e. in A1 is typed for example 100, in A22 is typed 65983, in B3 is typed 456...) and in the third column (C) I have to make a product of the A and B field in the same row (i.e. if in A1 is a number such as 100, in B1 number 50, in the field C1 has to print 5000 with a function). Is there a short way, a some kind of formula that makes a product of two fileds in the same row (A1, B1) and prints that product in the third filed (C1). It would realy help couse there are just too many rows for me to type in each one of the 'C' row =A1*B1 etc... Thx -- How does it sound when Darth Vader snores?! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
How to set a formula to count the product appear how manytime | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
If statement needed | Excel Worksheet Functions |