Can I enter two "IF" Functions in the same cell?

A

AcademyAce

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.
 
M

Martin Fishlock

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
 
D

daddylonglegs

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
 
D

driller

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.
 
Top