Forum Discussion

Copper Contributor

Feb 10, 2020

Needing Help with a formula

Hello, I am trying to make a formula where a cell is based on several different factors. I want the cell to calculate a roof priced based off the type of roof, how many squares, and the selected...

Formulas and Functions

jaredemmer

Copper Contributor

Feb 10, 2020

Riny_van_Eekelen

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.

Riny_van_Eekelen

Platinum Contributor

Feb 10, 2020

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.

jaredemmer
Copper Contributor
Feb 11, 2020
Riny_van_EekelenI would be open to doing a screen share so you could see