Problems with reference

[marcvanderpeet12]

Dear all,


I build a dashboard. Not sometimes this dashboard gives me a little hassle because the point of reference does not contain a value or contains #REF! Does anybody no a way in which I do not get a #HREF error when the reference point does not contain a value but for example a

0

.


Dear regards,


Marc

 

[Hui]

Marc


You can use the IFERROR Function


=Iferror(Function, Value)

eg:

=Iferror(A1/A2, 0) will display 0 if A2 is 0 causing an error

 

[marcvanderpeet12]

Thanks Hui, you're the man!