| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do you combine 2 or more formulas with different totals?
Im working on a formula that looks somewhat like this: =IF(G9100,1,IF(G9200,2,IF(G9300,3,))) but it isnt working...what I need is something that says...IF (G9) IS GREATER THAN 100 IT WILL EQUAL 1 AND IF GREATER THAN 200, IT WILL EQUAL 2 AND GREATER THAN 300, ETC ETC ETC...TILL I GET TO 1000 AND 10. WHAT AM I DOING WRONG? CAN SOMEONE PLEASE HELP ME? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
| Help combine 2 formulas into 1 | Excel Worksheet Functions | |||
| Combine two formulas in one cell | Excel Discussion (Misc queries) | |||
| How do I combine the 4 IF formulas into 1 formula | Excel Worksheet Functions | |||
| How can I combine IF, COLUMN, and LARGE formulas in a single cell? | Excel Worksheet Functions | |||
Threaded Mode
