jamward
03-13-2008, 05:44 AM
Hello all,
As a favor to a friend, I am trying to create this spreadsheet that will calculate coat and pants size based on user input for hips, waist and chest measurements. I have unhidden columns A thru J where size tables are located.
The premise is this: user will input name, measurements, etc. in columns L thru R. Results will be in columns S, T and U. Column T is based strictly on height measurement and is ok. Coat size is based on chest and weight measurements. If the "waist" is more that 3" higher than the "chest" measurement then the coat size will be increased to the next largest size. If the "HIP" measurement is more than 10" greater than the "waist" measurment then the pant size will be increased upwardly one size. I have attached entire spreadsheet with some embarrassingly pathetic code.
Thanks for concidering lending me a hand on this one.
As a favor to a friend, I am trying to create this spreadsheet that will calculate coat and pants size based on user input for hips, waist and chest measurements. I have unhidden columns A thru J where size tables are located.
The premise is this: user will input name, measurements, etc. in columns L thru R. Results will be in columns S, T and U. Column T is based strictly on height measurement and is ok. Coat size is based on chest and weight measurements. If the "waist" is more that 3" higher than the "chest" measurement then the coat size will be increased to the next largest size. If the "HIP" measurement is more than 10" greater than the "waist" measurment then the pant size will be increased upwardly one size. I have attached entire spreadsheet with some embarrassingly pathetic code.
Thanks for concidering lending me a hand on this one.