Forum Discussion
Solved
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 wil...
- 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
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.