Need to multiply a bunch of figures

[Grd]

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

 

[Beege]

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

 

[RagDyeR]

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!
=====================================================

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

 

[Grd]

GREAT
THANKS

=PRODUCT() ?

Beege