Multiple IF ??

[pmw19800]

Hello

i want to enter 1 number in A1 and text in A2 and return a spacific text in A3

i cant seem to combine 2 IF (Please see attched)
=IF(B1="Paul","Class 1")

Paul

[FDibbins]

So, what do you want the answer to look like?

[ChemistB]

You would nest them like so

=IF(B1="paul", "Class 1", IF(B1="Richard", "Class 2", IF(....)

How many names are there. Maybe a VLOOKUP would work better for you.

[AliGW]

What else do you want the formula to do? I don't understand what the second IF statement would need to check. Please be specific (your attachment doesn't really help).

[pmw19800]

i want to enter 5000003 in A1 and Paul in A2, I theses both are entered i want C1 to say Class 1

if they are not entered correctly return 0

[FDibbins]

Im sure there is more to this, but this gives you what you asked for...


=if(and(A1=50000003,B1="Paul),"Class 1",0)

[sandy666]

maybe: IF(AND(A1=5000003,A2="Paul"),"Class 1",0)

[pmw19800]

thanks FDibbins. Worked well

[FDibbins]

happy to help

(that is a VERY specific formula, and like I said, Im sure there is more to this than what you have said - probably see you back again soon )

[Richard Buttrey]

Hi,

Using your table in A1:C6
and 500000 in E1 and Paul in E2 then one way is with the Array formula

Please Login or Register  to view this content.

Note this is an array formula and must be entered with Ctrl-Shift-Enter. When you do in the formula bar you'll see the formula surrounded by { }