Thread
:
hide #VALUE!
View Single Post
#
1
Jim
Posts: n/a
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
Reply With Quote