Trying to help out a friend with an excel issue:
=IF(OR((ISERROR(C7/(C11-C13))),(C7/(C11-C13))<.005),"$0.00"),(C7/(C11-C13))
I'm trying to make the following command return $0.00 if it returns a value of less than .005 or if it returns an error. I keep getting a divide by zero error and I cannot figure out where to put my closing paren to make it work properly.
The OR operand is (supposed to be) making it so that if I get an error OR I have an answer that is less than 0.005 then I should be giving a response of $0.00.
=IF(OR((ISERROR(C7/(C11-C13))),(C7/(C11-C13))<.005),"$0.00"),(C7/(C11-C13))