Need help with formula...

  • Thread starter Thread starter Alberta Rose
  • Start date Start date
A

Alberta Rose

=IF(AND(K53=0,N53=0),0,IF(M53<(R53*0.1),MAX(K53,N53,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
 
your conditions all have true / false correctly set -- in other words the
final MAX() function returns when all tests are false.

replacing this with zero would do what you need... but i guess your formula
is there for a reason? have you missed another test?
 
your function looks ok in so far as every true/false is met with a value.
ths means that if all the tests are false, the final MAX() function is the
result.
so mayne you missed a test? replacing the final max() with a zero would give
you what you need.
 
Maybe...
=IF(ISERROR(AA53*AH53*K53*AD53),0,IF(AND(K53=0,N53=0),0,IF(M53<(R53*0.1),MAX(K53,N53,K53*AD53),
IF(V53<U53,AA53*AH53,MAX(K53,N53,AA53*AH53)))))

Note: the following replaces the equal sign in your formula...
=IF(ISERROR(AA53*AH53*K53*AD53),0,
Also, and additional ")" is required at the end of the formula.
--
Jim Cone
Portland, Oregon USA



"Alberta Rose"
<[email protected]>
wrote in message
=IF(AND(K53=0,N53=0),0,IF(M53<(R53*0.1),MAX(K53,N53,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
 
Back
Top