Excell help - imma noob

I'm trying to setup and 'if then' type formula. Basically, I'm setting a row where I want nothing done if the value is zero. If it's > zero, I want it to equal a formula, not a specified value.

The 'IF' function that I found only allows a specified value - such as IF G6=0, then G10 equals 'helmet', if not it equals 'head'.

I want G10 to equal the sum of several cells, not a defined value.

Anybody?

 

=IF(G10 > 0, SUM(Cell1, Cell2, Cell3))

or

=IF(G10 > 0, Cell1+Cell2+Cell3)

or

=IF(G10 > 0, SUM(A1:A10))

 

IF will let you have a true formula and a false formula

=IF(logical_test,value_if_true,value_if_false)

 

Yep, but it made the values equal specific things, not formulas. At least when I did it.

Imma try again with chip's suggestion.

 

Sweet - this is it:

=IF(H7>0,SUM(H7)-(B1),0)

Fucking excel was telling me to use brackets [ ] instead of parentheses ( ).

Allright - how about this one to save repeating the same basic thing:

I have a column that is 50 rows. I want that column to add the sum on several cells on each row. In other words:

one would be =SUM(C7:G7), the next =SUM(C8:G8), etc all the way to 55.

Is there a way I can do that without entering all the numbers?

 

just create the formula on one row, copy, select the range of cells you want it to go into and paste

 

Yes. Or, you should be able to select all the cells along the bottom and then click the sum icon.

 

HMMMMMM.

I got it to work on a simple formula, but not on this:

=SUM(H6)-(B1)*(B6)

the next would need to be:

=SUM(H7)-(B1)*(B7)

etc....

It worked doing this one:

=SUM(C10:G10)*(B10)

scratchy head thing.

 

$ anchors the reference so it doesn't change when copied. You can anchor the col, row, or both.

=SUM(H6)-($B$1)*(B6)

 

That was so awesome.