Hi! I'm very new to excel. Trying to create a program for window estimates. This formula creates a cost based on window size.
=IF(D3<6.01,226,IF(D3<7.01,247,IF(D3<8.01,265,IF(D3<9.01,282,IF(D3<10.01,298,IF(D3<11.01,316,IF(D3<12.01,331,IF(D3>=12.01,D3*27.59))))))))
My problem is there are 9 different window styles. 9 different lines of code similar to the above. I want to have a single cell do the following for eg.
If window style A is typed into cell B2, then use the formula which is in cell f3
If window style B is typed into cell B2, then use the formula which is in cell f4
and so on for all 9 styles. All in one cell. So all I have to do is type A, B... for one of the 9 styles & automatically get the relevant cost based on window size.
Sorry if this is convoluted, I'd really appreciate any help I can get.
In the eg. file I have the styles listed one by one. The K column holds the 9 different formulas at the moment.
I'd like to get rid of this list style, and be able to just type in on any given line "AWN" or "CF" or "CA" and have the relevant formula be applied in the K column.
Thanks, Steve.
Bookmarks