If function help

[LostinVA]

Novice here.. Can anyone help with the below formula? It seems to be working for the first condition but not the second IF.. Column BC contains the values 'Y', 'N', and blank. So the second IF should run if BC is not 'N' (BC would be 'Y' or blank)

IF(BC2 = "N", U2="NO", IF(R2=K2,"NO","YES"))

Appreciate all help, ty!

 

[6StringJazzer]

If BC2 = "N", your formula will return TRUE or FALSE based on whether U2="NO"
If BC2 <> "N" it will go to the second IF. What the second IF does is pretty clear.

If that is what you want your formula to do then it is correct. If it is not working as expected then your problem is in the data. What data do you have in R2 and K2? What result are you expecting?

Here is your formula in column A, and results for every combination of data you are checking. Looks OK to me.

$scratch.xlsm
	A										K							R			U																																		BC
2	FALSE																				YES																																		N
3	TRUE																				NO																																		N
4	YES										1							2																																					Y
5	NO										1							1																																					Y
6	YES										1							2
7	NO										1							1
Fractions

Cell Formulas
Range	Formula
A2:A7	A2	=IF(BC2 = "N", U2="NO", IF(R2=K2,"NO","YES"))

 

[LostinVA]

If BC2 = "N", your formula will return TRUE or FALSE based on whether U2="NO"
If BC2 <> "N" it will go to the second IF. What the second IF does is pretty clear.

If that is what you want your formula to do then it is correct. If it is not working as expected then your problem is in the data. What data do you have in R2 and K2? What result are you expecting?

Here is your formula in column A, and results for every combination of data you are checking. Looks OK to me.

$scratch.xlsm
	A										K							R			U																																		BC
2	FALSE																				YES																																		N
3	TRUE																				NO																																		N
4	YES										1							2																																					Y
5	NO										1							1																																					Y
6	YES										1							2
7	NO										1							1
Fractions

Cell Formulas
Range	Formula
A2:A7	A2	=IF(BC2 = "N", U2="NO", IF(R2=K2,"NO","YES"))

[/RA

Cell Formulas
Range	Formula

 

[LostinVA]

@6StringJazzer,

Thanks for your reply!

Here's what I'm trying to do:

If BC2 = "N", then the formula will return "NO" in U2.
If BC2 = "Y" or is blank then it it executes another formula where if R2=K2, then U2 = "NO". Otherwise, U2 = "YES"

Hope that makes sense! TY!

 

[Scott Huish]

Perhaps:
=IF(BC2="N","NO",IF(AND(OR(BC2="Y",BC2=""),R2=K2),"NO","YES"))

 

[LostinVA]

=IF(BC2="N","NO",IF(AND(OR(BC2="Y",BC2=""),R2=K2),"NO","YES"))

Ya'll are amazing, ty! I think this works exactly as I need it to. Brilliant!