If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I enter two "IF" Functions in the same cell?
I have used up all seven nested functions in my formula but still have three
arguments left. I want to include them in the same cell. |
#2
|
|||
|
|||
Can I enter two "IF" Functions in the same cell?
you can have more than 7 If functions nested in Vb code
"AcademyAce" wrote in message ... I have used up all seven nested functions in my formula but still have three arguments left. I want to include them in the same cell. |
#3
|
|||
|
|||
Can I enter two "IF" Functions in the same cell?
you can post your formula to see if this forum can help you.
"AcademyAce" wrote: I have used up all seven nested functions in my formula but still have three arguments left. I want to include them in the same cell. |
#4
|
|||
|
|||
Can I enter two "IF" Functions in the same cell?
rolYes you can:
=IF(IF(IF(IF(IF(IF(IF(IF(A1=1,1,1),1),1),1),1),1), 1),1)+IF(IF(IF(IF(IF(IF(IF(IF(A1=1,1,1),1),1),1),1 ),1),1),1) It is really difficult to understand the logic in multiple nested if statements and a user defined function is generally a lot easier to control and check you can also use 'and' and 'or' in if statements as =IF(OR(A1=1,A2=1,A3=1,A4=1,A5=1,A6=1,A7=1,A8=1,A9= 1,A10=1),1,0) - Hope this helps Martin Fishlock "AcademyAce" wrote: I have used up all seven nested functions in my formula but still have three arguments left. I want to include them in the same cell. |
#5
|
|||
|
|||
Can I enter two "IF" Functions in the same cell?
With 10 options it's usually better to use some sort of LOOKUP formula. If
you have the most simple structure like IF(A1="a",2,IF(A1="b",3 ......etc then this can usually be simplified by constructing a 2 column table and using a VLOOKUP formula "AcademyAce" wrote: I have used up all seven nested functions in my formula but still have three arguments left. I want to include them in the same cell. |
#6
|
|||
|
|||
Can I enter two "IF" Functions in the same cell?
you're right..
i just want to know here, (other than lookup results) if the number of different value-if-true results...requires more than 7 and are structured independently..... then nesting Maybe is a must... let's wait for AcademyAce to post his formula n Results needed... he sounds like an experienced excel user. "daddylonglegs" wrote: With 10 options it's usually better to use some sort of LOOKUP formula. If you have the most simple structure like IF(A1="a",2,IF(A1="b",3 ......etc then this can usually be simplified by constructing a 2 column table and using a VLOOKUP formula "AcademyAce" wrote: I have used up all seven nested functions in my formula but still have three arguments left. I want to include them in the same cell. |
Thread Tools | |
Display Modes | |
|
|