Anyone good with Excel?

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

Views: 13

▶ Reply to This

Replies to This Discussion

Permalink Reply by Kyung on October 25, 2008 at 21:08
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.

RSS

Latest Activity

Debbie Hennings posted a status
"Does anyone have a brief for when attorneys in court are picking a jury, using their strikes and peremptories, etc., but we're not on break?"
20 hours ago
0 Comments
Debbie Hennings is now a member of CSRNation
20 hours ago
Welcome Them!
Collette Stark joined Carolyn Ann Peterson's group
Thumbnail

Imperial Valley

Tuesday
0 Comments
Jacqueline Turl commented on Janet's page Proofreaders
Monday
Kristina Brown joined Kelli Combs (admin)'s group
Thumbnail

Cover Depos (Ventura County, Ca)

May 15
Kristina Brown joined Vance Jarvis's group
Thumbnail

Bakersfield

May 15
1 Comment
Kristina Brown updated their profile
May 15
Kristina Brown joined Kelli Combs (admin)'s group
Thumbnail

Cover Depos (International Depos)

May 15
Profile IconKristina Brown and Leslie Majchrzak joined CSRNation
May 15
Maria Mae Siatkowski joined Kelli Combs (admin)'s group
Thumbnail

Cover Depos (Corpus Christi & South TX)

May 15
Maria Mae Siatkowski updated their profile
May 15
Leslie Majchrzak updated their profile
May 14

© 2026   Created by Kelli Combs (admin).   Powered by

Badges  |  Report an Issue  |  Terms of Service