For Formula's sake

Joined
Oct 21, 2017
Messages
13
Hello, I hope everyone is doing well. I would love some help figuring out why an addition to my formula is not working. The original formula i am working with is =IF(ISNUMBER(SEARCH("GSI",AB1145 )),"GSI",IF(AB1145="NO CAMPAIGN","NO CAMPAIGN","CAMPAIGN")) and it works just fine. However, I need to add in an additional command, which is IF(V1134=0,"ABM Local"). The thing is, when i add in this new bit of formula, i keep getting back the same error message. "you have entered in to many argument for this function." I have tried nesting this new formula and it does not seems to help. I am hoping that someone here might be able to help.Thanks for your time and attention. Best,
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

philwojo

Well-known Member
Joined
May 10, 2013
Messages
533
What do you want it to do for that IF statement you want to add, and where do you want it in the original?
 
Joined
Oct 21, 2017
Messages
13
I would like the IF statement I am adding to be the false value. After following through the first check, I.e =IF(ISNUMBER(SEARCH("GSI",AB1145 )),"GSI",IF(AB1145="NO CAMPAIGN","NO CAMPAIGN","CAMPAIGN"))

I would the if statement i am adding to check in cell V1145 for a 0. if it finds a 0 i would like the formula to place the words "ABM Local" in the cell AA1145 if there is no 0 cell V1145 I would like the formula to leave a black space in cell AA1145. I would like to place this new part of the formula at the end of the original formula. But i am not picky. it can be placed anywhere that will allow it to work.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,412
Office Version
365
Platform
Windows
it can be placed anywhere that will allow it to work.
In nested formulas, when all the things you are checking are not checking the same cell (or are not dependent on each other), order matters, as a nested IF statement will STOP at the first true check it finds.

If you want that new condition as the last thing to check, try:
Code:
[COLOR=#333333]=IF(ISNUMBER(SEARCH("GSI",AB1145 )),"GSI",IF(AB1145="NO CAMPAIGN","NO CAMPAIGN",IF(V1134=0,"ABM Local"," ")))[/COLOR]
 

philwojo

Well-known Member
Joined
May 10, 2013
Messages
533
OK, maybe someone else will have some thoughts on this as well, but is your original formula also in cell AA1145?

I am not sure how to put the new portion in as your last part of your current formula already has a value for a "False" statement and that would be putting in "Campaign" if AB1145 <> "No Campaign".

Again, maybe someone else will have an idea, but at this time I'm not seeing it, but I am busy at work right now as well, so not fully thinking on this one.

Phil
 
Joined
Oct 21, 2017
Messages
13
Thanks so much for the help. But this did not work the way I need it to. I made a mistake in my initial question. all cells should be in row1145. After trying the formula you posted with the correct cells it is still not functioning the way i need it to. I appreciate your trying to help though Thanks so much.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,412
Office Version
365
Platform
Windows
Please provide us with the formula:
- Your current formula
- An example that is not working. Include the cell addresses and values in these cells, and your expected output (and logic behind it).
 
Joined
Oct 21, 2017
Messages
13
That is where i am having trouble. I would like to add this additional check in, but I am not sure how to keep the first false (Campaign) in and add the additional check.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,412
Office Version
365
Platform
Windows
You had mentioned two different false statements:
- return "CAMPAIGN" if AB1145 does not equal "NO CAMPAIGN"
- return a blank space is V1145 does not equal 0

You need to make a precedence decision - a single cell can only return "NO CAMPAIGN" or a blank space, but not both at the same time.
So the big question is, what should be returned if both AB1145 does not equal "NO CAMPAIGN" AND V1145 does not equal 0?
Which one wins? What should be returned in this case?
 
Joined
Oct 21, 2017
Messages
13
You had mentioned two different false statements:
- return "CAMPAIGN" if AB1145 does not equal "NO CAMPAIGN"
- return a blank space is V1145 does not equal 0

You need to make a precedence decision - a single cell can only return "NO CAMPAIGN" or a blank space, but not both at the same time.
So the big question is, what should be returned if both AB1145 does not equal "NO CAMPAIGN" AND V1145 does not equal 0?
Which one wins? What should be returned in this case?
So if both AB1145 does not equal "NO CAMPAIGN" AND V1145 does not equal 0 then that should mean there is a campaign name in AB1145 so "CAMPAIGN" should be returned. Ideally the formula will only look at V1145 after seeing there is no name or "No Campaign" in AB1145 and therefore there will be a 0 in V1145 so it will place "ABM-local" in cell AA1145.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,122
Messages
5,466,825
Members
406,501
Latest member
TheoDoc

This Week's Hot Topics

Top