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
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
![]()
d1 = if(a1<>"", b1 * c1, "")
Gre8888, Thanks a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks