IF statements help

[isomagaz]

What's wrong with this formula? and how many If statements can I put to one cell?

=IF(D15=4*(AND(H15>2,H15<5)),"Recommended",""), IF(D15=4*(AND(H15>=5,H15<15),"Required","")

[Miraun]

There ya go...

The problem is the comma before the second IF, change it to a &, and you're set
commas are used to separate syntax within a given function, while an ampersand is used to string together two separate functions

[arlu1201]

What are the conditions you are trying to put in?

[isomagaz]

Risk Assessment Template.xls

Thanks for the reply.

See attachment. Basically I am trying to populate Cell I15 with text dependant on the value in Cell D15 and the Class range it falls in to.

Gaz

[isomagaz]

OK. I have that working. Thanks.

Is there an umlimited amount of IF statements I can assign in this way? I have 11 to enter.

[Pepe Le Mokko]

OK. I have that working. Thanks.

Is there an umlimited amount of IF statements I can assign in this way? I have 11 to enter.

In that case using IF is probably not the best solution. Which are the conditions and their expected results?

[Pepe Le Mokko]

Perhaps

=IF(D15=4,IF(AND(H15>2,H15<5),"Recommended",IF(AND(H15>=5,H15<15),"Required")),"")

[isomagaz]

Pepe, see previous reply with the attachement.

[Pepe Le Mokko]

Pepe, see previous reply with the attachement.

Could you please explain?

[isomagaz]

Ive got this working how I want using If statements. Thanks for the advice about the '&'.

=IF(D15=4*(AND(H15>2,H15<5)),"Recommended","")&IF(D15=4*(AND(H15>=5,H15<=15)),"Required","")&IF(D15=3*(AND(H15>=0,H15<5)),"None","")&IF(D15=3*(AND(H15>=5,H15<8)),"Recommended","")&IF(D15=3*(AND(H15>=8,H15<=15)),"Required","")&IF(D15=2*(AND(H15>=0,H15<8)),"None","")&IF(D15=2*(AND(H15>=8,H15<11)),"Recommended","")&IF(D15=2*(AND(H15>=11,H15<=15)),"Required","")&IF(D15=1*(AND(H15>=0,H15<11)),"None","")&IF(D15=1*(AND(H15>=11,H15<14)),"Recommended","")&IF(D15=1*(AND(H15>=14,H15<=15)),"Required","")