formula apply if cell containt text

[santoshsapre]

A column containt text and in B C column having number, i want formula in D column if A contain Text then B1*C1

if A1 contain text then only apply formula in D1 (b1*c1 )

A B C D
1 SUN 5 2 10 ( requied answer )
2 MON 4 3 12
3 3 5 -
4 TUE 8 2 16

[ben_hensel]

Please Login or Register  to view this content.

[santoshsapre]

Gre8888, Thanks a lot.