here is an example: If box 1 or 2, add 15 to score
If box 3 or 4, add 36 to score This is all under one cell


"Anne Troy" wrote:

From your example, I can't figure out quite what you want to do, but this
may help:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"rnh" wrote in message
...
I need help!!! there is a formula i need to create...for example. "box 1 or
box2 adds to 15, box 4 or box 5 adds to 36. How does this work? I am able
to
creat one formula but how can i get both...I use formula =IF(B3=5. "25")
and
the answer comes out, but how can i get the second one?