name a formula

[daveturner80]

In our fire company we give out service pins for every 5 years of service.
I know that I can only have 7 nested formulas.
I am using the following formulas, but would like to use them as names.
=if(r3=5,5,if(r3=10,10,if(r3=15,15,if(r3=20,20,if(r3=25,25,if(r3=30,30,if(r3=35,35)))))))
=if(r3=40,40,if(r3=50,50,if(r3=55,55,if(r3=60,60,if(r3=65,65))))
<table border="0" cellpadding="0" cellspacing="0" width="80"><colgroup><col width="80"></colgroup><tbody><tr height="21"> <td class="xl65" style="height:15.75pt;width:60pt" height="21" width="80"> </td> </tr></tbody></table>Is there anyway I could name the top formula something like five to 35 and the second one forty to 65, and use this formula?
=if(fiveto35,fiveto35,fortyto65)
I thought I read somewhere that this could be done, or there easier formula that could be used?
Thanks for any help you can provide.
Dave
<table style="width: 80px; height: 1px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col width="80"></colgroup><tbody><tr height="21"> <td class="xl63" style="height:15.75pt;width:60pt" height="21" width="80"> <table border="0" cellpadding="0" cellspacing="0" width="80"><colgroup><col width="80"></colgroup><tbody><tr height="21"> <td class="xl65" style="height:15.75pt;width:60pt" height="21" width="80">
</td> </tr></tbody></table></td> </tr></tbody></table>

 

[crook_101]

Hi all,

Duplicate post answered here on MrExcel

http://www.mrexcel.com/forum/showthread.php?t=550124

Ian