I need to write a formula for the following.
Column E is a unit value of either "ea" (i.e. each) or "lf" (i.e. linear foot)
Column F is a unit defalt numerical value (i.e. sample 3.4)
Column "G" is my Factored unit value and where I need help. There is a factor value named "Material_Factor" on a sesperate page . My formula in column G will equal F x Material_Factor if the unit value in column E is "ea", but if the unit value in column E is "LF" the value in G needs to be F / 100 x Material_Factor.
Bookmarks