IF Statement

**loulaw** · 09-22-2013, 07:11 AM

HI,

I am trying to create an IF statement but cannot use a nested IF as i have more than 7 arguments.
Unfortunately, I can't seem to get the 'between' formula together and it's throwing me up errors.
I am using excel 2010 and need to put the following together:

<74 A
74-81 B
82-88 C
89-96 D
97-103 E
104-111 F
112-118 G
119-126 H
>127 I

Can anyone assist?
Many thanks in advance!

**popipipo** · 09-22-2013, 07:27 AM

Make a table and use the VLOOKUP formula

**L-Drr** · 09-22-2013, 07:51 AM

Doesn't this work for you?

=IF(A1<74,"A",IF(A1<82,"B",IF(A1<89,"C",IF(A1<97,"D",IF(A1<104,"E",IF(A1<112,"F",IF(A1<119,"G",IF(A1<127,"H","I"))))))))

I've assumed that when A1=127 (which is not mentioned in your explanation), the formula should result in "I".

**Rambo4711** · 09-22-2013, 08:21 AM

Or use this LOOKUP formula (if your value is in cell A1):

=LOOKUP(A1,{0,74,82,89,97,104,112,119,127},{"A","B","C","D","E","F","G","H","I"})

**Tony Valko** · 09-22-2013, 09:11 AM

Create a 2 column table and use a lookup formula.

Data Range

	A	B	C	D	E
1	Header1	Header2	-----	Lookup	Result
2	0	A		113	G
3	74	B
4	82	C
5	89	D
6	97	E
7	104	F
8	112	G
9	119	H
10	127	I

This formula entered in E2:

=LOOKUP(D2,A2:B10)

IF Statement

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

IF Statement

Re: IF Statement

Re: IF Statement

Re: IF Statement

Re: IF Statement

Thread Information

Users Browsing this Thread

Similar Threads

VBA Compile Error : line number or label or statement or end of statement

[SOLVED] Formula for Income Statement in financial statement

[SOLVED] Convert If statement with cell row reference calculations to vlookup statement

VBA- Compile Error, Expected: line number or label or statement or end of statement

[SOLVED] Utilize a Select Case Statement in Target Intersect Statement

Bookmarks

Bookmarks

Posting Permissions