| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I stop this appearing.......#DIV/0!
This appears in a cell when no information is in the `other` cells that it
calulates from #div/0! is there a way so that if no info in the cells then the cell with the formula remains (or appears) blank. thanks |
|
#2
|
|||
|
|||
|
=IF(A2="","",A1/A2)
-- Regards, Peo Sjoblom (No private emails please) "Scudo" wrote in message k... This appears in a cell when no information is in the `other` cells that it calulates from #div/0! is there a way so that if no info in the cells then the cell with the formula remains (or appears) blank. thanks |
|
#3
|
|||
|
|||
|
Try this, Scudo: =IF(ISERROR(A1),"",MYFORMULA)
Or: =IF(ISBLANK(A1),"",MYFORMULA) ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Scudo" wrote in message k... This appears in a cell when no information is in the `other` cells that it calulates from #div/0! is there a way so that if no info in the cells then the cell with the formula remains (or appears) blank. thanks |
|
#4
|
|||
|
|||
|
I should have put my formula in sorry.
=N5/B5 this is in cell L5 and #div/0! appears in L5 if N5 or B5 are blank. "Anne Troy" wrote in message news:47f8b$42c724a4$97c5108d$11649@allthenewsgroup s.com... Try this, Scudo: =IF(ISERROR(A1),"",MYFORMULA) Or: =IF(ISBLANK(A1),"",MYFORMULA) ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Scudo" wrote in message k... This appears in a cell when no information is in the `other` cells that it calulates from #div/0! is there a way so that if no info in the cells then the cell with the formula remains (or appears) blank. thanks |
|
#5
|
|||
|
|||
|
Use this in L5..........
=IF(OR(N5=0,B5=0),"",N5/B5) Vaya con Dios, Chuck, CABGx3 "Scudo" wrote in message .. . I should have put my formula in sorry. =N5/B5 this is in cell L5 and #div/0! appears in L5 if N5 or B5 are blank. "Anne Troy" wrote in message news:47f8b$42c724a4$97c5108d$11649@allthenewsgroup s.com... Try this, Scudo: =IF(ISERROR(A1),"",MYFORMULA) Or: =IF(ISBLANK(A1),"",MYFORMULA) ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Scudo" wrote in message k... This appears in a cell when no information is in the `other` cells that it calulates from #div/0! is there a way so that if no info in the cells then the cell with the formula remains (or appears) blank. thanks |
|
#6
|
|||
|
|||
|
That sorted it , Chuck
thanks "CLR" wrote in message ... Use this in L5.......... =IF(OR(N5=0,B5=0),"",N5/B5) Vaya con Dios, Chuck, CABGx3 "Scudo" wrote in message .. . I should have put my formula in sorry. =N5/B5 this is in cell L5 and #div/0! appears in L5 if N5 or B5 are blank. "Anne Troy" wrote in message news:47f8b$42c724a4$97c5108d$11649@allthenewsgroup s.com... Try this, Scudo: =IF(ISERROR(A1),"",MYFORMULA) Or: =IF(ISBLANK(A1),"",MYFORMULA) ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Scudo" wrote in message k... This appears in a cell when no information is in the `other` cells that it calulates from #div/0! is there a way so that if no info in the cells then the cell with the formula remains (or appears) blank. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop the activeX screen appearing when I open excel | Excel Discussion (Misc queries) | |||
| # DIV/0! error in Excel | Excel Discussion (Misc queries) | |||
| How do I stop additional "Xcel" icons appearing on desktop toolbar | Setting up and Configuration of Excel | |||
| How can I stop the clip board icon appearing after every paste | Excel Discussion (Misc queries) | |||
| Stop autofill icon from appearing? | Excel Discussion (Misc queries) | |||
Linear Mode
