IF(ISBLANK) with other criteria

C

CJ

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
 
B

Bernard Liengme

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

Alternative: =IF(ISERROR(LOG(D6)),"",LOG(D6))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top