Hi
I'm trying to write a formula using IF AND and OR. It needs to calculate:
if b>0
or a>0 and ((c+d)>786
then do ((c+d)*0.065)
or return a Zero
so far, I have got this, but Excel helpfully tells me I am missing a bracket, but not where - can anyone please help before I lose it completely!! Thanks, Nim
IF(OR(AND(B>0),AND(A>0,((C+D)>786),((C+D)*0.065),0)
Bookmarks