View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CJ CJ is offline
external usenet poster
 
Posts: 102
Default 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