If statement - simpler?

[psrs0810]

Is there a simpler way of writing this IF statement?

=IF(MONTH(B3)=7,11,IF(MONTH(B3)=8,10,IF(MONTH(B3)=9,9,IF(MONTH(B3)=10,8,IF(MONTH(B3)=11,7,IF(MONTH(B3)=12,6,IF(MONTH(B3)=1,5,IF(MONTH(B3)=2,4,IF(MONTH(B3)=3,3,IF(MONTH(B3)=4,2,IF(MONTH(B3)=5,1)))))))))))


Thank you!

 

[steve the fish]

Month 6?

 

[njimack]

Here's a starter for 10, although I'm sure it could be improved on...

=12-CHOOSE(MONTH(B3),7,8,9,10,11,12,1,2,3,4,5)

 

[mikerickson]

You could use LOOKUP

=LOOKUP(MONTH(B3),{5, 4, 3, 2, 1, 0, 11, 10, 9, 8, 7, 6})

or

=MOD(18-MONTH(B3), 12)

 

[njimack]

And here's the improved version...

=18-MONTH(B3)-IF(MONTH(B3)<6,12,0)

 

[steve the fish]

I dont think lookup will like that array will it mike?

 

[psrs0810]

I used MOD(18-MONTH(B3), 12) and it works perfectly!
thank you everyone!

 

[mikerickson]

I dont think lookup will like that array will it mike?

Oops, LOOKUP would want {1,2,3...,12} as an argument.
CHOOSE, similar to Nimjack's solution, would be better than LOOKUP for discreete situations

=CHOOSE(MONTH(B3),5, 4, 3, 2, 1, 0, 11, 10, 9, 8, 7, 6)