Thread
:
IF(ISBLANK) with other criteria
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
papou[_2_]
external usenet poster
Posts: 112
IF(ISBLANK) with other criteria
Hello CJ
=IF(ISBLANK(D6),"",IF(D6=0,0,LOG(D6)))
HTH
Cordially
Pascal
"CJ" a écrit dans le message de news:
...
Hello ALL
I use ISBLANK all the time as I don't like to see div or num errors in a
cell :)
I now want to add something to it, but not sure how ...
The formula in CELL E6 is this =IF(ISBLANK(D6),"",LOG(D6)) ... But when
I
type a zero into D6 I get a number error #NUM! ... I would like to add to
the
formula so when I type a zero into D6 it puts a zero in E6 ...
Any suggestions ...???
Thanks ... CJ
Reply With Quote
papou[_2_]
View Public Profile
Find all posts by papou[_2_]