Forum Discussion
DIVIDE error ?
HI who can explain me DIVIDE(blank(),0,5) - return BLANK DIVIDE(0,blank(),5) - return 5 if (ISERROR( blank()/0),1,2) - Return 2 NOT ERROR if (ISERROR( 0/blank()),1,2) - Return 1 ERROR ...
Straight from Microsoft's documentation: "Performs division and returns alternate result or BLANK() on division by 0."
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)