IF , text , numbers , decimal .

[Sunline]

Hello all , i have this function from here
=IF(A1-B1=20,"X","")
I want too change this too return the following results in another col but not sure how too .
IF A1=Good answer 10
IF A1=Rating 90 answer 20
IF A1=1 answer 40
IF A1=12= answer 50
IF A1=9.2 answer 60
IF A1=Good and IF B1=9.2 answer 70
IF A1=Good and IF B1=9.2 and IF C1=12= answer 80

If cells are blank return 0
Also how many Ifs can i join together using 2007 , basically covering all bases here , just need single functions rather than one big complicated one .
Thanks .

 

[T. Valko]

Hello all , i have this function from here
=IF(A1-B1=20,"X","")
I want too change this too return the following results in another col but not sure how too .
IF A1=Good answer 10
IF A1=Rating 90 answer 20
IF A1=1 answer 40
IF A1=12= answer 50
IF A1=9.2 answer 60
IF A1=Good and IF B1=9.2 answer 70
IF A1=Good and IF B1=9.2 and IF C1=12= answer 80

If cells are blank return 0
Also how many Ifs can i join together using 2007 , basically covering all bases here , just need single functions rather than one big complicated one .
Thanks .

Create this 2 column table:

Book1
	G	H
1	Good	10
2	Rating 90	20
3	1	40
4	12	50
5	9.2	60
Sheet1

Then your formula would be:

=IF(AND(A1="good",B1=9.2,C1=12),80,IF(AND(A1="good",B1=9.2),70,IF(COUNTIF(G1:G5,A1),VLOOKUP(A1,G1:H5,2,0),0)))

 

[Sunline]

Thanks for that , could i also get just 3 basic seperate functions for these
IF A1=Good answer 10
IF A1=1 answer 40
IF A1=9.2 answer 60
Thanks .

 

[T. Valko]

Thanks for that , could i also get just 3 basic seperate functions for these
IF A1=Good answer 10
IF A1=1 answer 40
IF A1=9.2 answer 60
Thanks .

Sure. Try these:

=(A1="good")*10

=(A1=1)*40

=(A1=9.2)*60

 

[Sunline]

Thankyou very much T. Valko .

 

[T. Valko]

Thankyou very much T. Valko .

You're welcome!