SRMPURCHASE
Board Regular
- Joined
- Dec 23, 2014
- Messages
- 212
- Office Version
- 2016
- Platform
- Windows
I have this nested IF formula that does not work, a constant keeps the formula from working. Then to work around the constant I tried an Index lookup as well that does not work.
Col S is typed in to designate a type of steel I need the weight per foot or square foot to be calculated.
W = Qty
Y =Thickness or wt per foot
Z = short side of steel
AA = long side of steel
AB = length of steel
Do I have all these arguments nested correctly? As I copy down the formula the rows change to correspond with the type of steel with dimensions is listed
If I use an Index/Vlookup formula how do I tell the formula to change to the corresponding row (some kind of wildcard for each row copied down).
Col S is typed in to designate a type of steel I need the weight per foot or square foot to be calculated.
W = Qty
Y =Thickness or wt per foot
Z = short side of steel
AA = long side of steel
AB = length of steel
Do I have all these arguments nested correctly? As I copy down the formula the rows change to correspond with the type of steel with dimensions is listed
If I use an Index/Vlookup formula how do I tell the formula to change to the corresponding row (some kind of wildcard for each row copied down).
=IF(S25=2,(Y25*Z25)+(AA25-Y25)*Y25*3.4032,0,IF(S25=3,(Z25*AA25*3.4032),0,IF(S25=4,(Y25*(AB25/12)*W25,0,IF(S25=5(Y25*AB25/12*W25,0,IF(S25=6,(Y25*(Z25*AA25/144)*W25,0,IF(S25=7,(Y25*(Z25*AA25/144)*W25,0,IF(S25=8,(Y25*(Z25*AA25/144)*W25,0,IF(S25=9,(Y25*Z25*3.4032,0,IF(S25=12,(Y25*Z25*ZZ25*.2836,0,IF(S25=13(Y25*Z25*AA25*.2836,0,IF(S25=14,(Y25*(Z25-Y25)*3.4032)+(Y25*AA25)*3.4032,0,IF(S25=16,(Z25-Y25)*Y25*4*.283,0) |