Change #Value! to 0

  • Thread starter Thread starter kenkozo
  • Start date Start date
K

kenkozo

hi, I have an excel worksheet where in cell c52, I divide C6/C20, which
gives me #value!. I know that this is because C6 = 0. I wanted to
know if anyone has any tricks where I can somehow use an IF statement
to turn the #value! into a 0. any help would be greatly appreciated.
cheers.
 
Hi Kenkozo!

=C6/C20 won't return #VALUE! if C6 = 0 unless C20 is text.

I'd check back at your problem and post back as you should be certain
of the cause of errors before you trap them.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top