C
Calvina Hayes
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
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