if anyone can help please i'm trying to create a formula that does the following:
If x and y are both blank return 0, but if either x or y is not blank return that value.
Thanks,
=if(and(x="",y=""),0,if(x<>"",x,if(y<>"",y,0)))
Perfect, thanks kidwispa.