Two Value if true, one value if false

[thirdeye85]

Hi there,


My question pertains to the =IF function, specifically having multiple conditional statements within one formula. Currently I have just one conditional statement at the top of the formula which I call, “CC” short for credit card transaction fees. When I denote “CC” to a particular column excel adds on a credit card percentage plus a flat rate of ten cents to another corresponding column.

The structure of my =IF function, If the cell does not equal to “CC”, than value if true would be value entered without credit card fees calculated, in my situation cash or check or some other variable. And then the value if false is my calculation for transaction fees.

My predicament is I would like to embed another conditional statement or variable within this formula. Instead of just “CC” I would like “CC” and “CC2” which would have different values calculated as needed. I believe what I am attempting to do is create two “value if true” followed by a “value if false”.


I tried tweaking my current formula with something like this, but to no avail:


=IF($B17<>"CC", “CC2”,


Am Incorrect in thinking that this is possible with the current IF formula because there is only one true and false statement, if so is there a more suitable formula for this? I was toying around with the =IFS formula and noticed that you can build multiple true statements within. Any help would be appreciated..

General_Ledger_2024.xlsx
	B	C	D	E	F	G	H	I	J	K	L
17	CC	1	1/3/24	Bank	Income	$ 90.00	$ 90.00	$90.00	$87.56	$87.56	$0.00
Test

Cell Formulas
Range	Formula
C17	C17	=MONTH([@Date])
I17	I17	=IF($B17<>"CC", IF($E17=J$1,-$G17,IF($F17=J$1,$H17,0)), IF($E17=J$1,-$G17,IF($F17=J$1,($H17),0)))
J17,L17	J17	=IF($B17<>"CC", IF($E17=J$1,-$G17,IF($F17=J$1,$H17,0)), IF($E17=J$1,-$G17 - ROUND($G17*0.026,2)-(MOD(ROUND($G17*1000,2),20)=5)/100-0.1,IF($F17=J$1,($H17 - ROUND($H17*0.026,2)-(MOD(ROUND($H17*1000,2),20)=5)/100-0.1),0)))
K17	K17	=IF($B17<>"CC", IF($E17=K$1,$G17,IF($F17=K$1,-$H17,0)), IF($E17=K$1,$G17 - ROUND($G17*0.026,2)-(MOD(ROUND($G17*1000,2),20)=5)/100-0.1,IF($F17=K$1,-($H17 - ROUND($H17*0.026,2)-(MOD(ROUND($H17*1000,2),20)=5)/100-0.1),0)))

 

[Joe4]

I am kind of confused by your explanation, but you can definitely have nested IF statement, and IF statements with multiple conditions, by using the AND and OR functions.

For example, if you wanted to first check to be if the value is NOT either CC or CC2, you could use:

=IF(AND($B17<>"CC,$B17<>"CC2"),...

And here is an article on nested IF formulas: IF function – nested formulas and avoiding pitfalls - Microsoft Support

 

[thirdeye85]

Hi there,

Thank you for the reply Joe. I applied the above function and it worked, however, it's not doing what I would like it to do. I understand the logic of the formula basically IF both CC & CC2 are input into cell B17 than "DO THIS", both conditions need to be met. I do not require both conditions to be met.

I would like Variable X if met, = Y, Variable T if met = Z

So I require different outputs for each variable. For instance, if CC is input "DO THIS1", if CC2 is input "DOTHIS2". They have different outputs depending on which variable is used.

 

[Joe4]

So I require different outputs for each variable. For instance, if CC is input "DO THIS1", if CC2 is input "DOTHIS2". They have different outputs depending on which variable is used.

Did you look at my link on Nested IFs? This is very easy with a simple nested IF, i.e.

=IF($B17="CC","DO THIS1",IF($B17="CC2","DO THIS2","Cell is neither value"))

 

[thirdeye85]

Thank you this worked like a charm. I couldn't make sense of the nested IF on the web-site but with your clarification it makes sense. Thanks so much!

 

[Joe4]

You are welcome!
Glad I was able to help.