Forum Discussion
IF Formula trouble
Hi there, I'm trying to create an IF formula for multiple scenarios. I have a drop down menu in a cell that contains about 8 different items with different prices. I want to make a formula that will calculate if any of the 8 items are picked, the price in the cell next to the item is selected. Any ideas? I'm driving myself crazy trying to figure it out. Thanks for any help!
- first, u need to try the formula below
=IF($I$9=orange,"4",IF($I$9=milk,"5",IF($I$9=apple,"6"," ")))
it's example for 3 items you can increase the formula as u need
give me your feed back
3 Replies
Jada,
There are a couple of different approaches to this. One is the first reply, and using a nested IF statement. If you use Office 365, you have a new function at your disposal. IFS allows for multiple criteria. It works the same as the nested IF, but it's much cleaner looking. The way that I would approach it would be to create a table with the items and their cost. The dropdown would refer to the Item column, and the formula would then be a VLOOKUP back to the table. The only reason I use an IF statement is to keep it from saying #N/A if the dropdown is blank. I've mocked it up for you in the attached workbook.
- first, u need to try the formula below
=IF($I$9=orange,"4",IF($I$9=milk,"5",IF($I$9=apple,"6"," ")))
it's example for 3 items you can increase the formula as u need
give me your feed back- Thanks so much!! You're genius! I just wasn't quite getting the right commas, etc. Have a wonderful day! You've certainly made mine more productive!
