miss-java
Mar 22, 2007, 10:32 AM
Hi,
I am a new member, I hope you could help me to complete my assignment tonight,
I am stock with "Count IF" function in Microsoft Excel 2003
How could I write the function with this commands:
Count if the Tax which is (E15) not equal to 0, then I want to use a nested if with these calculations:
=IF(C15<=1300,"£500",IF(C15>5000,"£2000",IF(C15>3000,"£2500",IF(C15>=2000,"£1500",IF(C15>=1400,"£550")))))
How can I put these tow conditions together?
--------------------
I came up with this, but Excel refuse it because it's wrong:
=countif(E15="17.5%",NO,If((C15<=1300,"£500",IF(C15>5000,"£2000",IF(C15>3000,"£2500",IF(C15>=2000,"£1500",IF(C15>=1400,"£550"))))))
Help me please :(
I am a new member, I hope you could help me to complete my assignment tonight,
I am stock with "Count IF" function in Microsoft Excel 2003
How could I write the function with this commands:
Count if the Tax which is (E15) not equal to 0, then I want to use a nested if with these calculations:
=IF(C15<=1300,"£500",IF(C15>5000,"£2000",IF(C15>3000,"£2500",IF(C15>=2000,"£1500",IF(C15>=1400,"£550")))))
How can I put these tow conditions together?
--------------------
I came up with this, but Excel refuse it because it's wrong:
=countif(E15="17.5%",NO,If((C15<=1300,"£500",IF(C15>5000,"£2000",IF(C15>3000,"£2500",IF(C15>=2000,"£1500",IF(C15>=1400,"£550"))))))
Help me please :(