LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Elbowhite
 
Posts: n/a
Default Product formula help


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding row to forumla carrera Excel Discussion (Misc queries) 9 August 23rd 05 10:24 PM
How to set a formula to count the product appear how manytime AMY Excel Worksheet Functions 3 March 21st 05 09:49 AM
IF & VLOOKUP FORMULA taxmom Excel Worksheet Functions 3 March 2nd 05 03:35 PM
Relative Indirect Formula Referencing? Damian Excel Worksheet Functions 1 January 7th 05 04:16 AM
If statement needed Patsy Excel Worksheet Functions 1 November 4th 04 03:48 PM


All times are GMT +1. The time now is 01:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"