Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
On one of my worksheets I am creating a standard report that is doing quite a
number of calculations. On occassions my data in certain areas will be null. For example cell H34 is returning the error because it has been looking for type 5 priorities and there are none. I am a fussy person and want to suppress the error message as it looks untidy. I have looked at a few threads and cannot quite find one that sorts this out. Thanks up front to all you patient people out there that take your time out to help others. -- Regards vipa |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to sum cells and ignore the #div/0! 's ? | Excel Worksheet Functions | |||
#DIV/0!.......how to get rid of it | Excel Discussion (Misc queries) | |||
replace "#DIV/0!" error with blanks | Excel Worksheet Functions | |||
# DIV/0! error in Excel | Excel Discussion (Misc queries) | |||
blank instead of DIV/0! | Excel Discussion (Misc queries) |