| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple IF formulas
Can I put more than on IF formula in a cell?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple IF formulas
Yes, there are several ways to do that. What are you really trying to do?
One way: =IF(<condition1,1, 2) + IF(<condition2, 3, 4) another: =IF(<condition1, 1, IF(<condition2, 2, 3)) In article , sriddle wrote: Can I put more than on IF formula in a cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple IF formulas
Yes.
I think you can nest upto seven IFs in a formula. =IF(cond1,IF(cond2,do_true_2,do_false_2),do_false_ 1) ... "sriddle" wrote: Can I put more than on IF formula in a cell? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple IF formulas
Yes, here's one example with 3 IFs:
=IF(A1="","blank",IF(A1<0,"negative",IF(A10,"posi tive","zero"))) Hope this helps. Pete On Dec 9, 11:35*pm, sriddle wrote: Can I put more than on IF formula in a cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you use multiple if formulas with multiple choices? | Excel Worksheet Functions | |||
| Multiple formats in a single cell with multiple formulas | Excel Worksheet Functions | |||
| Multiple-Value formulas | Excel Worksheet Functions | |||
| Sort multiple columns with multiple formulas without returning #R | Excel Worksheet Functions | |||
| Multiple Formulas | Excel Discussion (Misc queries) | |||
Hybrid Mode
