I want to add a group of numbers. If that sum is greater than 0, I want the
sum to be multiplied by a number.

I need help if anyone can tell me how.

Thanks.

How about something along the lines of:

=IF(SUM(A1:A40)0,SUM(A1:A40)*10,SUM(A1:A40))

Substituting the A1:A40 range and the number 10 to those relevant to your
formula.
--
Kevin Backmann


"YB Girl" wrote:

I want to add a group of numbers. If that sum is greater than 0, I want the
sum to be multiplied by a number.

I need help if anyone can tell me how.

Thanks.

Say the number to multiply is entered in B1, and you want to total the
numbers in A1 to A10:

=IF(SUM(A1:A10)0,B1*SUM(A1:A10),0)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"YB Girl" <YB wrote in message
...
I want to add a group of numbers. If that sum is greater than 0, I want
the
sum to be multiplied by a number.

I need help if anyone can tell me how.

Thanks.