Multiple if function
Hello,
I'm trying to create multiple IF functions with more than 5 conditions.
Below is what I'd like to achieve;
Assume the formula is written in F2
- = If A2 = "Red" then F2 should be changed to "New" if not then leave it as it is
- = If B2 = "BIG" then F2 should be changed to "New BIG" if not then leave it as it is
- = If B2 = "SMALL" and F2 = "Old" then F2 should be changed to "Old SMALL" if not then leave it as it is
- = If B2 = "SMALL" and F2 = "New" then F2 should be changed to "New SMALL" if not then leave it as it is
- = If B2 = "MEDIUM" and F2 = "Old" then F2 should be changed to "Old MEDIUM" if not then leave it as it is
- = If B2 = "MEDIUM" and F2 = "New" then F2 should be changed to "New MEDIUM" if not then leave it as it is
- = If B2 = "MEDIUM" and F2 = "Gone" then F2 should be changed to "Gone MEDIUM" if not the leave it as it is
- = If B2 = "MEDIUM" and F2 = "Broken" then F2 should be changed to "Broken MEDIUM"
Actually I could do it just by using the filter but I'm doing this 3 times a week so I kind of need a better approach especially with automation.
Any help would be so much appreciated.
Cheers,
Last edited by Andalusia; 11-11-2009 at 06:24 AM.
Edit:
Looking over this, there's a rather important question:
That's awfully vague. Is there a value or a formula already in this cell?...leave it as it is
Last edited by mewingkitty; 11-10-2009 at 10:59 AM.
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
Yes there is a value in there already, I will need to change the value in that column.Any Idea?
A sample workbook would be very helpful.
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
There you go!
What I need to change here is the Group of District Desc based on
District Desc and Country
so if i re-phrase my question
- IF District Desc = "GTO AUTOMOTIVE" then I need to change the Group of District Desc from "OTHER" to "GGD"
- IF Country = "RUSSIA" then I need to change the Group of District Desc from "BBA" to "BBA RUSSIA"
- IF COUNTRY = "ISRAEL" AND Group of District Desc = "SLOERT" then I need to change the Group of District Desc from "SLOERT" to "SLOERT ISRAEL"
- IF COUNTRY = "ISRAEL" AND Group of District Desc = "INDIRECT" then I need to change the Group of District Desc from "INDIRECT" to "INDIRECT ISRAEL"
- IF COUNTRY = "MCO" AND Group of District Desc = "SLOERT" then I need to change the Group of District Desc from "SLOERT" to "SLOERT MCO"
- IF COUNTRY = "MCO" AND Group of District Desc = "INDIRECT" then I need to change the Group of District Desc from "INDIRECT" to "INDIRECT MCO"
Have I explained it better?
See attached.
I didn't really see any solid pattern to your conditions so I went with a big ugly if statement.
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
Re: Multiple if function
Sweet Dude! It works! You're BRILLIANT!
now i just need to record this with MACRO and.. the pain is gone!
THANKS A LOT!
Last edited by Andalusia; 11-11-2009 at 06:22 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks