IF AND ELSE formula

[LeighMacKay7]

Hi,
I am hoping somebody can help me, please.

I am not even sure if I am going down the right route in terms of a formula.
I think it is an =IF(AND formula with multiple logic.
I just can't seem to apply the logic.


There are four different types of possibilities, which help me to get the 2022/23 Answer (as shown below)

2021/22 Answer	Manual Changes (if required)	2022/23 Answer
UT	"Blank"	"Blank"
"Blank"	UT	UT
"Blank"	"Blank"	"Blank"
UT	UT	UT

If the table says "Blank". Normally it would contain nothing in the cell.

Basically, the Manual Changes (if required) column, overrides what is in the 2021/22 answer, even if it is "Blank". And returns the data in 2022/23 Answer column.

Can anybody point me in the right direction please.

Thanks in advance
Leigh

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1	2021/22 Answer	Manual Changes (if required)	2022/23 Answer
2	UT		UT
3		UT	UT
4
5	UT	UT	UT
Data

Cell Formulas
Range	Formula
C2:C5	C2	=IF(COUNTIFS(A2:B2,"?*")=2,B2,CONCAT(A2:B2))

 

[Joe4]

I am a bit confused/unclear if the grid in the original post is what the OP wants to happen, or if it is what is currently happen.
If it shows what they want to happen, then there is an issue with the formula Fluff provided for row 2 (it appears they want "blank" and not "UT" in that scenario).

If there table in the original post shows the desired outcome, it seems to me that you simply always want what is showing in the second column, does it not?
If so, the formula should just be:

=IF(B2="","",B2)

 

[Phuoc]

Maybe like this:

Book1
	A	B	C
1	2021/22 Answer	Manual Changes (if required)	2022/23 Answer
2	UT
3		UT	UT
4
5	UT	UT	UT
Sheet1

Cell Formulas
Range	Formula
C2:C5	C2	=IF(B2="UT","UT","")

 

[LeighMacKay7]

Maybe like this:

Book1
	A	B	C
1	2021/22 Answer	Manual Changes (if required)	2022/23 Answer
2	UT
3		UT	UT
4
5	UT	UT	UT
Sheet1

Cell Formulas
Range	Formula
C2:C5	C2	=IF(B2="UT","UT","")

I have tried this one and it doesn't work.
Because where the Change column now needs to be blank. It still pulls through the "UT" text.
Thank you for your reply though. Much appreciated.

 

[Joe4]

I have tried this one and it doesn't work.
Because where the Change column now needs to be blank. It still pulls through the "UT" text.
Thank you for your reply though. Much appreciated.

You received two other replies before that one that you have not addressed.
If neither of those work for you, please try explaining again in more detail, walking us through an example that doesn't work, explaining the logic behind that one.

 

[LeighMacKay7]

How about

Fluff.xlsm
	A	B	C
1	2021/22 Answer	Manual Changes (if required)	2022/23 Answer
2	UT		UT
3		UT	UT
4
5	UT	UT	UT
Data

Cell Formulas
Range	Formula
C2:C5	C2	=IF(COUNTIFS(A2:B2,"?*")=2,B2,CONCAT(A2:B2))

Thank you for your time and response to my message.

This one doesn't work either.


As when the answer should be "blank", it still returns the UT text.

I might have to re-think the way in which I am working with the data. And use "0" or "N/A"

 

[Fluff]

Can you post some realistic data showing exactly what you have & explain what the results should be.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Joe4]

This one doesn't work either.

What about my first reply (post #3)?
It seems to return what you showed in your original post.

 

[LeighMacKay7]

I am a bit confused/unclear if the grid in the original post is what the OP wants to happen, or if it is what is currently happen.
If it shows what they want to happen, then there is an issue with the formula Fluff provided for row 2 (it appears they want "blank" and not "UT" in that scenario).

If there table in the original post shows the desired outcome, it seems to me that you simply always want what is showing in the second column, does it not?
If so, the formula should just be:

=IF(B2="","",B2)

This one doesn't work either. It just returns "0".

The confusion is that. as shown on my initial message.
If the answer should be an empty cell. But is currently a UT. It returns UT.