Formula Problem

  • Thread starter Thread starter YB Girl
  • Start date Start date
Y

YB Girl

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.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Error 6
Excel Formula or equation 3
sum last 3 numbers greater that 0 in a range 0
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Excel How to add numbers in same cell? 2
Sumif number is greater than a number but less than another number 2
if formula 4
Sumproduct question 4

Back
Top