Ignoring zero's

[joeholiday]

Sorry I know this question's been asked before but I just don't get it!

How do I ignore the cells in Column D which contain 0 when doing a natural logarithm.

eg.. Column E looks like =LN(D21)

But I want it to ignore the cells with 0 value. At the moment it comes out at #NUM! Please help.

 

[VoG]

Try

=IF(D21>0,LN(D21),"")

 

[Sachin.Medhe]

Try Out !

=IF(LN(D21)="","",LN(D21))

 

[joeholiday]

Thankyou Vog, that works perfectly! And sorry to be a pain but in the next column I want to do =E21*D21

...so I tried

=IF(E21>0,(E21*D21),"")
but this then comes out as #VALUE!

Any ideas?

 

[VoG]

Try

=IF(E21<>"",E21*D21,"")

 

[joeholiday]

Legendary! Thankyou so much. I dont understand what it's doing but it works you beautiful genius!