How could I put 2 conditions with COUNT IF Function and NESTED IF in Excel model

miss-java · #1 Mar 22, 2007, 09: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 funtion 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>30 00,"£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 becuase it's wrong:
=countif(E15="17.5%",NO,If((C15<=1300,"£500",IF(C1 5>5000,"£2000",IF(C15>3000,"£2500",IF(C15>=2000,"£ 1500",IF(C15>=1400,"£550"))))))

Help me please

asterisk_man · Mar 22, 2007, 09:38 AM

not sure what you want exactly.
where'd the 17.5 come from? where'd the NO come from?
can you post the exact assignment please?

miss-java · Mar 22, 2007, 12:15 PM

sorry, for not giving more details in the first time, i am a student and my second language is english, so i hope that you become peitent with me.

this is how my Excel model looks like,

in the image, i highlighted the tow columns that i want to consider. the column that i want to put Count IF function is labled (loan price)
As you see, some cars are not available in the Gallery, so i put (coming soon), if you follow the row you will notice that there's no tax for that car because the car is not yet in the gallery, so (Loan price ) cloumn should show (0)
if you could help me to sort the function out to be able to put the same criteria for (insurance),( Actual monthly price), (VAT) columns because they should show (0) as well.

So how could I manage to say:
If the car is not available Or (the TAX is 0) ,then the loan price should be a Zero , if the Tax is 17.5% then the loan price should be as the amount givin for each car model.

in the other way ,

Count the loan price as givin if the Tax is not 0

Hope that you get me this time, and sorry for my english

Miss Java

miss-java · Mar 22, 2007, 01:04 PM

yes, but how can i use COUNT IF instead NESTED IF



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!