Re: another IF query

In article <BF7520C4.5584F%bob@xxxxxxxxxx>, Bob Greenblatt <bob@xxxxxxxxxx>
wrote:


> Yes, You've got your parentheses mixed up. Try:
>
> =IF(P12="yes",IF(M12<N12/1000*$N$5,N12/1000*$N$5),IF(P12="New",N12*$N$5/1000
> ,IF(B12="R",M12*(1+$N$4),M12*(1+$N$3))))
>
>
> I think this is right, but it's hard to see what you really mean due to the
> line wrap. So, it should look like this:
>
> =if(p12="yes,do stuff,if(p12="new",do other stuff,do blank stuff))

Undoubtedly I am mixed up. Thanks for the reply.
This also has some unintended reactions.

Here's what I am trying to do, in words.

If P12 is "new" then there is a simple calculation _ N12*N5/1000

but if it isn't "New" then I have another question.

Is P12 "yes"?. If it is then I need to know if M12 is greater than N12*N5/1000.

If it is greater, use it _ M12. Otherwise use N12*N5/1000.

But if P12 is not "yes", that is anything BUT New or yes, then ask if B12 ="R".

If so then the answer is M12*(1+N4), otherwise it's M12*(1+N3)

Hope this is not too confusing.

Harvey




--
RIGHT
"Property Taxes - The only tax we pay
according to what others can afford"
http://righttax.org
.