Is there any better way to set out multiple IF statements?

KnAsTa · Apr 13th, 2002, 03:01 AM

Cos i am using a formula with about 4 If statements in it, and i am finding it hard to read and it is getting quite confusing. :|
Thanx

Dave Patton · Apr 13th, 2002, 08:35 AM

Yes

Check Help on boolean, Vlookup, HLookup, Lookup, Choose, etc.

Ricky Morris · Apr 13th, 2002, 07:22 PM

Try using the OR function

James · Apr 13th, 2002, 07:56 PM

"If" statements can get very confusing and
hard to read, that's why the "real guys"
suggest using "select case" you may want to
it.

James

Ricky Morris · Apr 13th, 2002, 08:42 PM

Select Case is only available in VBA but not in the Excel application.

KnAsTa · Apr 13th, 2002, 11:33 PM

So how do you write a formula using the VBA instead of the formula box?

Jay Petrulis · Apr 13th, 2002, 11:43 PM

Quote:

On 2002-04-13 22:33, KnAsTa wrote:
So how do you write a formula using the VBA instead of the formula box?

Hi,

Please show us your formula (or describe in detail what you'd like to do).

Thanks,
Jay

nisht · Apr 13th, 2002, 11:45 PM

if you have multiple conditions and you want to use if statements. the best way is to use.

Select Case testexpression
[Case expressionlist-n
[statements-n]] ...
[Case Else
[elsestatements]]

End Select

you can see the how select statement can be used by taking on line help also

this is the best way to go.

nishith desai
http://www.pexcel.com

KnAsTa · Apr 13th, 2002, 11:45 PM

=IF(ISERROR(LOOKUP(A5,week1.xls!$A$1:$A$10,0)),IF(VLOOKUP(A5,week1.xls!$A$1:$D$10,3,0)>VLOOKUP(A5,week1.xls!$A$1:$D$10,4,0),3,0),IF(ISNA(LOOKUP(A5,week1.xls!$A$1:$D$10,4)>VLOOKUP(A5,week1.xls!$A$1:$D$10,3,0)),3,0))

Thats the formula using 3 IF statements.
Confusing?

nisht · Apr 13th, 2002, 11:58 PM

There are people you use boolean by multiplications and additions and returns the values..

one is i suppose from arnold site.. where he has explained how to use without 'IF'

i have have downloaded his sample file where he has given the example ..

his address
http://geocities.com/aaronblood

nishith desai
http://www.pexcel.com

Apr 13th, 2002, 07:22 PM	#3
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	Try using the OR function __________________ It's never too late to learn something new. Ricky

Apr 13th, 2002, 08:42 PM	#5
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	Select Case is only available in VBA but not in the Excel application. __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 13th, 2002, 03:01 AM	#1
KnAsTa Board Regular Join Date: Apr 2002 Location: Australia Posts: 52	Cos i am using a formula with about 4 If statements in it, and i am finding it hard to read and it is getting quite confusing. :\| Thanx

Apr 13th, 2002, 08:35 AM	#2
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	Yes Check Help on boolean, Vlookup, HLookup, Lookup, Choose, etc.

Apr 13th, 2002, 07:56 PM	#4
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	"If" statements can get very confusing and hard to read, that's why the "real guys" suggest using "select case" you may want to it. James

Apr 13th, 2002, 11:33 PM	#6
KnAsTa Board Regular Join Date: Apr 2002 Location: Australia Posts: 52	So how do you write a formula using the VBA instead of the formula box?

Apr 13th, 2002, 11:45 PM	#8
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	if you have multiple conditions and you want to use if statements. the best way is to use. Select Case testexpression [Case expressionlist-n [statements-n]] ... [Case Else [elsestatements]] End Select you can see the how select statement can be used by taking on line help also this is the best way to go. nishith desai http://www.pexcel.com

Apr 13th, 2002, 11:58 PM	#10
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	There are people you use boolean by multiplications and additions and returns the values.. one is i suppose from arnold site.. where he has explained how to use without 'IF' i have have downloaded his sample file where he has given the example .. his address http://geocities.com/aaronblood nishith desai http://www.pexcel.com