Need to multiply a bunch of figures
Hi there,
I have a set of figures 24, 20, 30, 10 that I need to multiply with eachother. I want the computer to do this for me without me having to multiply each cell. Is there an equivilant to the Sum function. I'm really stuck and I need to do this for my boss Any help would be greatly appreaciated Thanks Suzanne |
Need to multiply a bunch of figures
Grd wrote:
Hi there, I have a set of figures 24, 20, 30, 10 that I need to multiply with eachother. I want the computer to do this for me without me having to multiply each cell. Is there an equivilant to the Sum function. I'm really stuck and I need to do this for my boss Any help would be greatly appreaciated Thanks Suzanne =PRODUCT() ? Beege |
Need to multiply a bunch of figures
Individually:
=Product(24,20,30,10) In an array, say A1 to A4" =Product(a1:a4) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Grd" wrote in message ... Hi there, I have a set of figures 24, 20, 30, 10 that I need to multiply with eachother. I want the computer to do this for me without me having to multiply each cell. Is there an equivilant to the Sum function. I'm really stuck and I need to do this for my boss Any help would be greatly appreaciated Thanks Suzanne |
Need to multiply a bunch of figures
GREAT
THANKS "Beege" wrote: Grd wrote: Hi there, I have a set of figures 24, 20, 30, 10 that I need to multiply with eachother. I want the computer to do this for me without me having to multiply each cell. Is there an equivilant to the Sum function. I'm really stuck and I need to do this for my boss Any help would be greatly appreaciated Thanks Suzanne =PRODUCT() ? Beege |
All times are GMT +1. The time now is 07:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com