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

R

rnh

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

rnh

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
 
Top