Anyone good with Excel?

[Marla Sharp]

I'm trying to figure out an if/then formula and am having trouble. If anyone is any good at those formulas, please email me. I'm trying to do a formula which says if cell A is greater than 1 and if cell B is greater than 1, then total those (equals 2). Does that make sense?

Thanks!

Marla

[Kyung]

I think what you want is an "IF" formula. The asterisk equals and.


=IF((A1>1)*(A2>1),SUM(A1:A2))

If A1 is greater than 1 and A2 is greater than1, then add together A1 through A2.

Oh, by the way. I have Excel 2003. I assume it works the same if you have a newer version. But I could be wrong. Tell me if this is what you're looking for. I'm interested to know.