More than one range in an IF(AND function

[apar93]

Is it possible to put more than one range in an IF(AND( function. For example: IF(AND(A27>=1,A27<=3),A27*5),IF(AND(A27>=4,a27<=6)A27*6)
Is there a way I can do this? Because excel doesn't allow me to.

 

[Jonmo1]

You have a misplaced ), and you're missing a comma.
IF(AND(A27>=1,A27<=3),A27*5),IF(AND(A27>=4,a27<=6)A27*6)
That red ) is basically ENDING the first IF, instead of continuing it (Nesting the next if)
It should be
IF(AND(A27>=1,A27<=3),A27*5,IF(AND(A27>=4,a27<=6),A27*6))

 

[steve the fish]

Sure you just have it a bit wrong:

=IF(AND(A27>=1,A27<=3),A27*5,IF(AND(A27>=4,A27<=6),A27*6,"Whatever the false should be"))

A nested if works by putting a new if statement into the false part of the previous if.

 

[Jonmo1]

That said, here's a couple alternate methods to try.

You don't need the AND functions there, as long as you put the if's in the right order.
=IF(A27>=7,"not specified",If(A27>=4,A27*6,IF(A27>=1,A27*5)))
or a little simpler
=IF(A27>=7,"not specified",A27*If(A27>=4,6,IF(A27>=1,5)))