| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0! error
I have a spreadsheet where the formula is =(G38-E38-F38)/E38 and goes down the entire column. Its a percentage that shows up when there are numbers put into the rows, but it shows the #DIV/0! error when there isn't anything in the rows. Is there a way to just keep the cell blank when there isn't any numbers in the row instead of showing an error?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#DIV/0! error
Hi Erin,
Am Fri, 7 Aug 2015 10:14:12 -0700 (PDT) schrieb : I have a spreadsheet where the formula is =(G38-E38-F38)/E38 and goes down the entire column. Its a percentage that shows up when there are numbers put into the rows, but it shows the #DIV/0! error when there isn't anything in the rows. Is there a way to just keep the cell blank when there isn't any numbers in the row instead of showing an error? try: =IF(E38=0,"",(G38-E38-F38)/E38) or: =IFERROR((G38-E38-F38)/E38,"") Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
| Error handling error # 1004 Run-time error | Excel Programming | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
| Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Linear Mode
