Logical if more than 7
In future, please do not SHOUT.
Put this formula in F2:
=IF(ISNA(MATCH(B2,B3:B13,0)),"not valid",IF(B2="ST",
2*(C2+D2+E2),IF(B2="HR",8*C2+2*D2,C2+D2+E2)))
You didn't have a condition for B2="CH" - this assumes C2+D2+E2.
Hope this helps.
Pete
On Jul 25, 4:10*pm, vmohan1978
wrote:
* * *A * * * * * * * * B * * * * * * * * * * * * * *C * * * * * *D * * * * * *
* * E * * * * * * * * * * * * * * * F
* * *1 *shape of bar * *a * * * b * * * c * * * formula required
*2 * * *BB * * * * * * * * * * * * * * *
* * 3 * TB * * * * * * * * * * * * * * *
* * 4 * S * * * * * * * * * * * * * * *
* * 5 * L * * * * * * * * * * * * * * *
* *6 * *SB * * * * * * * * * * * * * * *
*7 * * *Z * * * * * * * * * * * * * * *
* * 8 * ST * * * * * * * * * * * * * * *
9 * * * CH * * * * * * * * * * * * * * *
10 * * *SCB1 * * * * * * * * * * * * * *
11 * * *SCB2 * * * * * * * * * * * * * *
12 * * *HR * * * * * * * * * * * * * * *
I WANT THE FORMULA *IN F2 *IF B2=BB OR TB OR S OR SB OR Z OR SCB1 OR SCB2
THEN F2= C2+D2+E2 THEN *, IF B2=ST THEN F2=2*( C2+D2+E2) ,IF B2=TB THEN
C2+D2+E2, IF B2=HR THEN F2= 8*A+2*B.
PLEASE DO THE NEEDFUL.
|