| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Clear all cell entries EXCEPT formulas? | Excel Discussion (Misc queries) | |||
| Formulas in a cell | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Excel formulas based upon the color shading of a cell? | Excel Worksheet Functions | |||
Linear Mode
