Forum Discussion
Needing Help with a formula
Always difficult to help on the basis of a few screen shots. Though, one observation I made is that the prices for each type of roof are based on a fixed price per Sqft (at least for the first 17 sizes visible in the screenshot with the Input sheet). Then there is no need to list out all the prices for every possible size. Just use Size X Sqft Price to calculate the total cost. This might eliminate much of the IF statements that you say to be using. Not sure, though, that this is the case. Therefore, it would be good if you could upload a sample of your workbook (without any confidential information) indicating what values/numbers you expect to see where and based on what logic.
Thank you for the response. The reason why I listed them all out is that they change with the selected interest rate so its not a fixed price. If you were to select a different term for the financing amount, the cost of the roof will change.
So for example:
The 10 year 2.99% Comp Roof = $468
The 25 Year 3.49% Comp Roof = $489
So every different financing option, the price change.
I did the comp roof with a bunch of if statements.
I can't add the other two roof selections
I want to have the drop down box of those three roof types. If I select wood shake, I want to select how many squares and have it equal that value it corresponds with.
jaredemmer Would be better if you could demonstrate in a workbook what you have achieved so far. It seems that you are not trying to accomplish something very complicated. Excel offers a variety of lookup and matching functions and drop-downs are easy to create. Don't really understand why you would need a lot of IF functions at all. But.... I would have to see your schedule to be sure.
Riny_van_EekelenI would be open to doing a screen share so you could see
_LI.jpg){kind=link}
_LI.jpg){kind=link}