How do you set up two formulas in one cell? 1+2=3 or 4+5=6
 

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?

How do you set up two formulas in one cell? 1+2=3 or 4+5=6
 

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?

How do you set up two formulas in one cell? 1+2=3 or 4+5=6
 

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?

How do you set up two formulas in one cell? 1+2=3 or 4+5=6
 

Where is "box 3 or 4 or 1 or 2"? Where is the score?
************
Anne Troy
www.OfficeArticles.com

"rnh" wrote in message
...
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?

How do you set up two formulas in one cell? 1+2=3 or 4+5=6
 

THANK YOU FOR YOUR HELP...YOUR INFORMATION HELPED ME VERY MUCH.

RANDA

"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?