Multiple IF Statements

[jeffv]

I'm am trying to put together a cost analysis of a project and need some IF statement help. I have a dropdown list in H5 that has a couple of different supply options. In H6, I would like it to fill in the cost associated with that supply item if that one is chosen. I am not a formula guru but I'm assuming there's a way to do this?

Thanks

[alansidman]

Here is a quick lesson on If statements
http://www.techonthenet.com/excel/formulas/if.php

[jeffv]

Thanks. I don't see anything specifically like mine and I tried a couple of them but I can't get them to work. I'll try to describe it better. I have 2 options in the drop down list

3yr. 5mbps
3yr. 10mbps

If I choose 3yr. 5mbps in the drop down list, I want H6 to fill in $200.00. If I choose 3yr. 10mbps, I want H6 to fill in $185.00

Does that make sense?

Thanks again.

[alansidman]

=if(H5="3yr. 5mbps", 200,185) This works if you only have two options in your drop down. Put this formula in H6

Alan

[Harribone]

jeffv.xlsx

This will be more suited to a VLOOKUP function. I have attached an example for you.

Please Login or Register  to view this content.

VALUE This is the value to look for (in your case H5)
RANGE The range to look for the value (the value needs to be in the first column of this range)
COLUMN_TO_RETURN The column number which contains the value you are wanting to return (in your case the cost)
0 0 if you want to find an exact match, 1 to find nearest match (you will want 0)

I do recommend you look more into looking up values (start with VLOOKUP but there are other ways) to help you better understand this and what you can do with this.

Hope this helps

[jeffv]

alansidman: Thank you, that worked. However, if nothing is selected, it defaults to the 185 in the cell. Not a huge deal but I would like it hidden until something is selected in H5. Also, I do have another drop down list that I'll be doing this to and it has 4 entries in it. What do I need to do in that case?

Harribone:Thanks, I haven't ever used vlookup so I'll give it a shot.

[Harribone]

If you choose Alans route modify this to =IF(H5="3yr. 5mbps", 200,IF(H5="3yr. 10mbps",185,"")).

If you want to develop your options further change the "" to a new IF statement.

[alansidman]

As you get more selections you will be better served exploring the vlookup function as Harribone has indicated.

Here is a link to help http://www.techonthenet.com/excel/formulas/vlookup.php

[jeffv]

If you choose Alans route modify this to =IF(H5="3yr. 5mbps", 200,IF(H5="3yr. 10mbps",185,"")).

If you want to develop your options further change the "" to a new IF statement.

Awesome! Thank you guys so much. Just in time to get it finished before the weekend.