Suppose , you will check this following details:

1. If A1 = 1 then 1
2. If A1 = 2 then 2
3. If A1 = 3 then 3
4. If A1 = 4 then 4
5. If A1 = 5 then 5
6. If A1 = 6 then 6
7. If A1 = 7 then 7
8. If A1 = 8 then 8
9. If A1 = 9 then 9
10. If A1 = 10 then 10
11. If A1 = 11 then 11
12. If A1 = 12 then 12
13. If A1 = 13 then 13
14. If A1 = 14 then 14
15. If A1 = 15 then 15



Define this formula as OneToSix:

Example:
=IF($A$1=1,1,IF($A$1=2,2,IF($A$1=3,3,IF($A$1=4,4,I F($A$1=5,5,IF
($A$1=6,6,IF($A$1=7,7,IF($A$1=8,8,FALSE))))))))

and your formula as SevenToThirteen:

=IF($A$1=9,9,IF($A$1=10,10,IF($A$1=11,11,IF($A$1=1 2,12,IF($A$1=13,13,
IF($A$1=14,14,IF($A$1=15,15,"NotFound")))))))

The combined formula looks like this:

=IF(OneToSix,OneToSix,SevenToThirteen)


VN,