Thread: hide #VALUE!
View Single Post
  #1   Report Post  
Jim
 
Posts: n/a
Default hide #VALUE!

I am using the following formula:

=IF(I71=0,"0%",I71/I74)

I71 has this formula:
=IF(J67=0,"",J67)

When no data shows in I71 I am receiving #VALUE! in the cell that should
return 0%, how can I fix this error?

Thanks