Johnny Thunder
Well-known Member
- Joined
- Apr 9, 2010
- Messages
- 693
- Office Version
- 2016
- Platform
- MacOS
Hello all,
I am working on a little bit of a crazy formula and have come to a road block. Hopefully someone knows of a solution or even another way to write this formula.
So here goes,
Formula A:
Formula B:
Definitions:
Logo1 - Logo5 = Named ranges
Logo1 - Logo5 with "SUB" in name = Subtotal Range
Logo1 - Logo5 with "UnSUB" in name = Unlicensed Subtotal Range
So what I am trying to accomplish is having these two formulas (A & B) combined with some sort of logic that says:
IF(AND(B17=Logo1 AND S17<>"True" Return Logo1Sub But if S17="True" then Return Logo1UnSub.
Written out Properly: =IF(AND(B17=Logo1,S50<>"True"),Logo1Sub,Logo1UnSub)
My issue is, how do I apply this to all the variables in 1 formula?
This is the formula combing two variable but results in an error because how it is combined.
I am working on a little bit of a crazy formula and have come to a road block. Hopefully someone knows of a solution or even another way to write this formula.
So here goes,
Formula A:
Code:
=IF(AND(B17=Logo1,D17=Market2),Logo1RSub,IF(B17=Logo1,Logo1Sub,IF(B17=Logo2,Logo2Sub,IF(B17=Logo3,Logo3Sub,IF(B17=Logo4,Logo4Sub,IF(B17=Logo5,Logo5Sub,""))))))
Formula B:
Code:
=IF(AND(B17=Logo1,S17="True"),logo1UnSub,IF(AND(B17=Logo2,S17="True"),logo2UnSub,IF(AND(B17=Logo3,S17="True"),Logo3UnSub,IF(AND(B17=Logo4,S17="True"),logo4UnSub,IF(AND(B17=Logo5,S17="True"),logo5UnSub,"")))))
Definitions:
Logo1 - Logo5 = Named ranges
Logo1 - Logo5 with "SUB" in name = Subtotal Range
Logo1 - Logo5 with "UnSUB" in name = Unlicensed Subtotal Range
So what I am trying to accomplish is having these two formulas (A & B) combined with some sort of logic that says:
IF(AND(B17=Logo1 AND S17<>"True" Return Logo1Sub But if S17="True" then Return Logo1UnSub.
Written out Properly: =IF(AND(B17=Logo1,S50<>"True"),Logo1Sub,Logo1UnSub)
My issue is, how do I apply this to all the variables in 1 formula?
This is the formula combing two variable but results in an error because how it is combined.
Code:
=IF(AND(B50=Logo1,S50<>"True"),Logo1Sub,logo1UNSub),(IF(AND(B50=Logo2,S50<>"True"),Logo2Sub,logo2UNSub))
Last edited: