OK, I am trying to interpolate and perform calculations from a table based on multiple variables at the same time. I have sort of figured out part using nested if statements, but it is getting ugly fast, so I am hoping for some help. What I have is a table defining how to find the value for Ca. That value is based on 3 inputs, whether something is flat or round, a predetermined value of C, and something called the Aspect Ratio. If a user selects a flat object, and the aspect ratio is less than 2.5, Ca = 1.2. If The aspect ratio if between 2.5 and 7, then the sheet needs to interpolate Ca somewhere between 1.2 and 1.4, and so on. If the user selects round, it gets more complicated. I have linked to the table and some sample data to hopefully show what I am looking for. I need to fill in the Ca column with the proper value based on the requirements in the table and the data given. Any ideas?
Here is a link to the file I created:
https://docs.google.com/file/d/0B5EhXFGoVZAvZ2wyMDVUbzRQNVk/edit?usp=sharing
Here is a link to the file I created:
https://docs.google.com/file/d/0B5EhXFGoVZAvZ2wyMDVUbzRQNVk/edit?usp=sharing
