hi can anyone please explain to me the operator precedence rule in this
formula :

This formula works as what i wanted:
=IF(B510000,D5*50%,IF(B50,D5*25%,\"NO TAX\"))
The above is the correct formula, my b5=4500, so my answer is 1125. The
formula works.

but i tried to experiment using the following:

*=IF(B510000,B5*50%,IF(*10000B50*,B5*25%,"No Tax")) *----this
works,displays 1125

*
=IF(B510000,B5*50%,IF(*0<B5<10000*,B5*25%,"No Tax"))* ----this doesn't
work, displays no tax.

hope someone can explain it to me ..thank you very much. i know this is
something about precedence but i need more details about this.


--
SFH
------------------------------------------------------------------------
SFH's Profile: http://www.excelforum.com/member.php...o&userid=32512
View this thread: http://www.excelforum.com/showthread...hreadid=522999