I need help finding a SQ FT Formula

[TCSAlex]

Is there anyone out there that has found a basic SQ FT calculating formula, Ive read into some forums and I've came across this formula,
=LEFT(D19,FIND("'",D19)-1)*SUBSTITUTE(RIGHT(D19,LEN(D19)-FIND("x ",D19)-1),"'","") , Im currently having to go into the formula and changing the cell It will calculate, I want to add a basic formula that will go into a drop down menu, PLEASE HELP!!!!!!!

 

[TCSAlex]

Is there anyone out there that has found a basic SQ FT calculating formula, Ive read into some forums and I've came across this formula,
=LEFT(D19,FIND("'",D19)-1)*SUBSTITUTE(RIGHT(D19,LEN(D19)-FIND("x ",D19)-1),"'","") , Im currently having to go into the formula and changing the cell It will calculate, I want to add a basic formula that will go into a drop down menu, PLEASE HELP!!!!!!!

A formula that will adjust to each cell AUTOMATICALLY*********

 

[jasonb75]

That formula should adjust automatically once you have it set correctly for the first cell.

Not sure what you mean by

I want to add a basic formula that will go into a drop down menu

though, you can't have formulas in dropdowns.