IF statements with AND and OR

[ReFFi]

Hey all-

Usually I can figure these out on my own, but Im definitely stumped this time around. Any help would be appreciated. Here's the formula I have so far, and I'm sure I'm just missing a comma or paranthesis somewhere.


=IF(AND((B108>0),(F108>0)),IF((C109="Color Charge"),SUM(F108:H108,F109)),IF((C110="Color Charge"),SUM(F108:H108,F110),IF((C111="Color Charge"),SUM(F108:H108,F111),SUM(F108:H108))," ")

The AND part is is basis to make sure that I there is actually an amount to pull, so I got that part down, but some of the ads that have an amount have a color charge and that needs to be added to the amount, BUT stupid way our statements come out sometimes put the line right underneath the ad, or a line or two down. Hope people are still following this, so I added a few IF statements to check to see if the cell a line or two or three down had that description and if it does to ad the appropriate cell. If I need to add the spreadsheet, I will draft one up quickly. Let me know please! Thanks in advance!


<edit> A note to add, if the AND part does not complete both logics, then at the end of the statement I have the " ") as for a blank, because no amount is needed then. I think I gave about all I need. Let me know!

<edit> Last edit, scratch the OR, no need for it in this formula.

[ReFFi]

Ok, it appears I figured it out, there are other things I want to add, but I think excel 2002 can only handle what, up to 7 nested IF statements? Correct me if I'm wrong.


=IF(AND((B168>0),(F168>0)),IF((C169="Color Charge"),SUM(F168:H168,F169),IF((C170="Color Charge"),SUM(F168:H168,F170),IF((C171="Color Charge"),SUM(F168:H168,F171),SUM(F168:H168))))," ")

The corrected formula.

[ReFFi]

Ok one last thing, and then I'll stop being a nuissance!

I am attaching a sample of three lines, I got my original problem solved, but I think I have started to confuse myself.

I need to add two more Logics to the whole process and I'm not sure excel can be capable of this.

If it happens to be that B3 is the amount where everything is being summed and the description (C2 = (Credit or Debit)% (percent being a wild card), then add my highlighted column G2 to B3.

Hope this makes sense.

[NBVC]

How about?

Please Login or Register  to view this content.

[ReFFi]

How about?

Please Login or Register  to view this content.

Didn't appear to work NBVC, I did figure out what I was doing wrong, however, in my latest post, I attached a sample of what I'm doing, and the couple of things I have to do from here on out.

Thank you for the feedback however!

[NBVC]

Unless you don't have more If's, Then you could try in I2:

Please Login or Register  to view this content.

Are you sure you mean b3 in the previous post?