IF statement is baffling me - please help!!

[sam.tidswell-norrish]

Hi,

If I have column A with either the letter A, B, C or D in it, and I want to create an IF statement for column B so that if column A is an A or B it says 'Top of Class' in column B, and if column A is a C or D it says 'Bottom of Class' in column B, what IF formula do I use?

 

[aravindhan_31]

use this in B2 and drag down

=IF(OR(A2="A",A2="B"),"Top of the Class",IF(OR(A2="C",A2="D"),"Bottom of the Class"))

 

[VoG]

Try

=IF(OR(A1="A",A1="B"),"Top of class",IF(OR(A1="C",A1="D"),"Bottom of class",""))

 

[Weaver]

Welcome to the board.

=if(A2>"B","Bottom of Class","Top of Class")

ought to do it, assuming you're working with caps throughout and your data starts in row 2.

HTH

 

[Boller]

<TABLE style="WIDTH: 269pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=358><COLGROUP><COL style="WIDTH: 269pt; mso-width-source: userset; mso-width-alt: 13092" width=358><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 269pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17 width=358>=IF(OR(A1="A",A1="B"),"Top of Class", "Bottom of Class")</TD></TR></TBODY></TABLE>

 

[Boller]

Welcome to the board.

=if(A2>"B","Bottom of Class","Top of Class")

ought to do it, assuming you're working with caps throughout and your data starts in row 2.

HTH

Nice one !

 

[sam.tidswell-norrish]

I'm using this one as I'm modifying the titles fromA/B/C/D and top of class / bottom of class, but it just says false in column B when I input it...?

 

[VoG]

Which one?

Excel Workbook
	A	B
1	C	Bottom of class
Sheet3

 

[sam.tidswell-norrish]

Yes, this one. If i'm more specific maybe it'll help.

Column A contains either of the following words:

Environmental, Integration, Functional, Set Up, Non Functional, Performance or Security.

I would then like in Column B it to say the following:

IF Environmental or Integration then = Test Environment
IF Functional or Set Up = Business Functional
IF Non Functional or Performance or Security = Technical (Non Functional)

 

[jamieleeuk]

ignore me