| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to create Multiple Conditional Formulas in a single cell?
How do I for create Multiple Conditional Formulas in a single cell?
For example: =IF(B5<0,IF(K5="Short",(L5-M5)*10000,(M5-L5)*10000),"") is one of the equations, but I need it to multiply by 100 instead of 10000 if the answer is greater than 1000. I could also have it so it multiplies the different equation if word criteria in a different cell from the same row is different. I dont know how to do that either. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting using result of Cell Formulas | Excel Discussion (Misc queries) | |||
| how do i use multiple conditional formats in one cell? | Excel Discussion (Misc queries) | |||
| Displaying the results of multiple formulas in a single cell. | New Users to Excel | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
