View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alberta Rose Alberta Rose is offline
external usenet poster
 
Posts: 54
Default Need help with formula...

=IF(AND(K53=0,N53=0),0,IF(M53<(R53*0.1),MAX(K53,N5 3,K53*AD53),
IF(V53<U53,AA53*AH53,MAX(K53,N53,AA53*AH53))))

If none of the conditions in the above formula are met, I would like to
return a value of zero. I'm unsure of how to do this. Help please :)

Thanks...Laurie