2 IFERROR Functions?

Hi Guys,

I want to have 2 IFERROR functions in my calculation.

Currently I have

Please Login or Register  to view this content.

which I change to

Please Login or Register  to view this content.

for instances shown below.

I want to change it so that if C4 is >0 it will return "0%" and if C4 is <0 it will return "No Data"

Can this be done?

if(iserror(c4/b4),if(c4>0,"0%",if(c4<0,"no data","")))

Unless C4 always has to have a value, currently 0 is also excluded as neither condition is >= or <=

Regards

Dav