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
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
=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!