- #1
mcreech
- 1
- 0
Hello,
I am really struggling to write a math formula that I need for my website plugin.
A=(Length) B=(Width) C=(Square Inch)
A*B=C
0<=C<=16 then C*.84
17<=C<=34 then C*.70
35<=C<=65 then C*.56
66<=C<=99 then C*.42
100<=C<=150 then C*.35
151<=C<=500 then C*.31
I wrote this formula in excel, but I need a pure math formula. Here is the excel formula…G2 represents sq in. =IF(G2<=16,G20.84,IF(G2<=34,G20.7,IF(G2<=65,G20.56,IF(G2<=99,G20.42,IF(G2<=150,G20.35,IF(G2<=200,G20.31))))))Any help would be much appreciated, Thanks!
I am really struggling to write a math formula that I need for my website plugin.
A=(Length) B=(Width) C=(Square Inch)
A*B=C
0<=C<=16 then C*.84
17<=C<=34 then C*.70
35<=C<=65 then C*.56
66<=C<=99 then C*.42
100<=C<=150 then C*.35
151<=C<=500 then C*.31
I wrote this formula in excel, but I need a pure math formula. Here is the excel formula…G2 represents sq in. =IF(G2<=16,G20.84,IF(G2<=34,G20.7,IF(G2<=65,G20.56,IF(G2<=99,G20.42,IF(G2<=150,G20.35,IF(G2<=200,G20.31))))))Any help would be much appreciated, Thanks!