|
Question
 | | | | | 
Mar 22, 2007, 10:32 AM
|  | New Member  | | Join Date: Mar 2007
Posts: 4
| | | How could I put 2 conditions with COUNT IF Function and NESTED IF in Excel model
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 
| | | | | | |
Answers
| | | | | |
Mar 22, 2007, 10:38 AM
|
#2
| | Full Member
Join Date: Nov 2006 Location: East coast of U.S.A.
Posts: 476
| 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? |
 | | | | | | | | | | | | |
Mar 22, 2007, 10:53 AM
|
#3
| | | Computer Expert and Renaissance Man
Join Date: Jan 2003 Location: LI, NY - USA
Posts: 33,709
Pay to call ScottGem for advice ($.75/min) | The assignment is not clear at all. CountIF counts the number of cells in a range that match a value.
If you want a certain calculated value to appear in a cell based onthe value of a nother cell, the nested Ifs are the right approach. Maybe:
=IF(E15<>0,.175, IF(C15<=1300,500,IF(C15>5000,2000,IF(C15>30 00,2500,IF(C15>=2000,1500,IF(C15>=1400,550))))))
You don't want to uses strings, you want to use numbers and format them for currency. | |
| | | | | | | | | | | | |
Mar 22, 2007, 01:15 PM
|
#4
| | New Member
Join Date: Mar 2007
Posts: 4
| 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 | |
| | | | | | | | | | | | |
Mar 22, 2007, 01:16 PM
|
#5
| | | Computer Expert and Renaissance Man
Join Date: Jan 2003 Location: LI, NY - USA
Posts: 33,709
Pay to call ScottGem for advice ($.75/min) | Did you try the function as I posted it earlier? | |
| | | | | | | | | | | | |
Mar 22, 2007, 02:04 PM
|
#6
| | New Member
Join Date: Mar 2007
Posts: 4
| yes, but how can i use COUNT IF instead NESTED IF | |
| | | | | | | | | | | | |
Mar 22, 2007, 05:38 PM
|
#7
| | | Computer Expert and Renaissance Man
Join Date: Jan 2003 Location: LI, NY - USA
Posts: 33,709
Pay to call ScottGem for advice ($.75/min) | Quote: |
Originally Posted by miss-java yes, but how can i use COUNT IF instead NESTED IF | Why are using CountIF? | |
| | | | | | | | Thread Tools | Search this Thread | | | | | Display Modes |  Linear Mode | Ask your question or search...
|
Search this Thread |
|
Bookmarks
| |
|
