Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
isBlank() | Excel Worksheet Functions | |||
ISBLANK | Excel Worksheet Functions | |||
IF(ISBLANK) | Excel Worksheet Functions | |||
If(ISBLANK) | Excel Worksheet Functions | |||
ISBLANK | Excel Worksheet Functions |