Bug with advanced if statment?
1000 is greater than 250, so the answer from your first IF condition is
1000*15%. It doesn't get as far as any of the other tests.
You'll need to reverse the order of the tests.
--
David Biddulph
"H4X3R" wrote in message
...
Hello im using the follow if statment
=IF(C21250,C21*15%,IF(C21=500,C21*25%,IF(C21=10 00,C21*50%,"NO")))
it works fine but when it comes accross a number "1000" it doesnt times it
by 50% for e.g 1000*50% is ment to be 500 the if statment gives me 150
anyone
help thanks!
|