Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Would greatly appreciate it if someone could help me with this error. I am
using Excel 2003. My formula at the moment is =SUM(C2-B2) / B2 * 100 as i have copied this formula down the spreadsheet where there is no value in the b column cells I get the error message #DIV/0! I have tried the argument =IF(ISERROR(C2/B2),"",C2/B2) but i must not be using it correctly as i then get an #value error message. Would be grateful if someone could tell me how to alter my formula so I can get rid of #DIV/0! message as it looks untidy and I don't want it to print out when I produce a hard copy. Many Thanks. Kindest Regards Calvina Hayes |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Message Box | Excel Discussion (Misc queries) | |||
VBA Error Message "Compile Error...." | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions | |||
Help with error message - please! | Excel Worksheet Functions | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |