I had read someone on this site who asked- find a letter "p' in a sequence of numbers to show "paperback" ... I took that formula and made changes to this-=IF(FIND("8x8x7",A2)<"","64","") "64" being the sq ft. it works. except that is just one. Their are 40 combinations. I tried to repeat the sequence in my own way but it didn't work. Something like this...=IF(FIND("8x8x7",A2)<"","64",""),IF(FIND(" 10x10x7",A2)<"","100","")IF(FIND("12x14x7",A2)<" ","168","") and so on and so on... This was my first question in needing a formula.

Now when you enter the size I was hoping to trigger a preselected wood list of material and prices for that shed to be filled out on a separate worksheet to print later.

Hi,ch;16

Am Thu, 11 Apr 2013 09:10:25 +0200 schrieb Claus Busch:

Function sqrfeet(rngc As Range) As Double

sorry for the sqrfeet. You can change it to inch ;-)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2[/quote]