| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Ifs!
Hello, For multiple conditioned IF function, it would be best to use the IFS Function in excel.
IFS function work the same as the IF function, but: =ifs(Logical test 1, value if true1, logical test 2, value if true 2...) this can hold more conditions that your usual if function. it also makes things easier to type and look at. Hope this helps! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Hybrid Mode
