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