hello
If cell d1 =>0(zero) then
k1 = "blue"
if cell d1 = "any word" then
k1 = ""
i mean if d1 have numeric value then result should be "blue" in k1
if
d1 have a words then result should be ""
thanx
hello
If cell d1 =>0(zero) then
k1 = "blue"
if cell d1 = "any word" then
k1 = ""
i mean if d1 have numeric value then result should be "blue" in k1
if
d1 have a words then result should be ""
thanx
Here!
=IF(ISNUMBER(D1),"Blue","")
Deep![]()
Cheers!
Deep Dave
thanx msexcelathome
works perfect
+1 repu added to u![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks