IF Statements

[MarkAndrews]

I know you can only nest 7 IF statements in a standard formula

My question is, How can i do more?

TIA

 

[Peter_SSs]

Could i do the same with the introducer too?

Edit: Sorry, originally messed this up. I think this is what you want:
=VLOOKUP(B2,Workings!$D$2:$E$18,2,0)

 

[MarkAndrews]

Thankyou!

Out of curiosity - Can more than 7 IF's be achieved?

 

[MarkAndrews]

Peter, This isn't working correctly (see below example)

The Introducer ID = 40 (YourMove)

it isn't displaying Yourmove?

Abort Data.xls
	A	B	C	D	E	F	G	H	I	J
1	ClientID	IntroducerID	MatterID	StartDate	AbortDate	AuthActDate	AuthactReceived	Client	Networkdays
2	10	40	563785	03/01/06	NULL	NULL	No	GenericSAP		#N/A
Jan

 

[Peter_SSs]

Thankyou!

Out of curiosity - Can more than 7 IF's be achieved?

You cannot nest more than 7 together but you can write a formula using lots of IFs that simulate more than seven nested together - but why would you when there are simpler alternatives?

 

[MarkAndrews]

Thankyou!

Out of curiosity - Can more than 7 IF's be achieved?

You cannot nest more than 7 together but you can write a formula using lots of IFs that simulate more than seven nested together - but why would you when there are simpler alternatives?

It was just a curiosity thing Peter

I was thinking - could you reference a single if statement to other cells which each contain 7 If's?

 

[Peter_SSs]

This isn't working correctly (see below example)

The Introducer ID = 40 (YourMove)

it isn't displaying Yourmove?

Your sample of the 'Workings' sheet did not have an Introducer ID of 40. You probably just need to expand the range in the formula. Instead of $E$18 you might need $E$25 or whatever row your Introducer IDs finish on.

 

[MarkAndrews]

Peter, This isn't working correctly (see below example)

The Introducer ID = 40 (YourMove)

it isn't displaying Yourmove?

Abort Data.xls
	A	B	C	D	E	F	G	H	I	J
1	ClientID	IntroducerID	MatterID	StartDate	AbortDate	AuthActDate	AuthactReceived	Client	Networkdays
2	10	40	563785	03/01/06	NULL	NULL	No	GenericSAP		#N/A
Jan

I've sorted this, sorry - I needed to extend the vlookup range as below (e56)

=VLOOKUP(B2,Workings!$D$2:$E$56,2,0)

 

[MarkAndrews]

=VLOOKUP(B2,Workings!$D$2:$E$56,2,0)

I note, this doesn't contain True/False - How does this work?

 

[Peter_SSs]

=VLOOKUP(B2,Workings!$D$2:$E$56,2,0)

I note, this doesn't contain True/False - How does this work?

0 is equivalent to FALSE
1 is equivalent to TRUE

 

[MarkAndrews]

Ah, I never knew that

Thanks for all your help Peter