IF(ISBLANK) with other criteria
 

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

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

IF(ISBLANK) with other criteria
 

Maybe

=IF(OR(D6=0,ISBLANK(D6)),"",LOG(D6))

Mike

"CJ" wrote:

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

IF(ISBLANK) with other criteria
 

Remember that if D6 has a formula such as =IF(D510,D5,""), then even when
D5 is less than 10, cell D6 will never pass the ISBLANK test.

Alternative: =IF(ISERROR(LOG(D6)),"",LOG(D6))
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"CJ" wrote in message
...
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

IF(ISBLANK) with other criteria
 

Thank you so much, Pascal :)

CJ

"papou" wrote:

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

IF(ISBLANK) with other criteria
 

My pleasure ;-)

Cordially
Pascal

"CJ" a écrit dans le message de news:
...
Thank you so much, Pascal :)

CJ

"papou" wrote:

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