For Formula's sake

[HelpINeedSomebodysHelp]

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,

 

[Joe4]

Then it sounds like this is what you want:

[COLOR=#333333]=IF(ISNUMBER(SEARCH("GSI",AB1145 )),"GSI",IF(AB1145="NO CAMPAIGN","NO CAMPAIGN",IF(V1134=0,"ABM Local","CAMPAIGN")))[/COLOR]

and what you said here earlier was not correct:

if there is no 0 cell V1145 I would like the formula to leave a black space in cell AA1145

as you just said:

V1145 does not equal 0 then that should mean there is a campaign name in AB1145 so "CAMPAIGN" should be returned.

 

[HelpINeedSomebodysHelp]

Then it sounds like this is what you want:

[COLOR=#333333]=IF(ISNUMBER(SEARCH("GSI",AB1145 )),"GSI",IF(AB1145="NO CAMPAIGN","NO CAMPAIGN",IF(V1134=0,"ABM Local","CAMPAIGN")))[/COLOR]

and what you said here earlier was not correct:

as you just said:

I appreciate the help. this was not exactly what i was looking for but i was able to get some help.all i had to do was forget about V1145 and and in another ISNUMBER(SEARCH portion to the formula

thank you all so much though love this community.