Formula Problem
 

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.

Formula Problem
 

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.

Formula Problem
 

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.