LeighMacKay7
New Member
- Joined
- Oct 11, 2022
- Messages
- 34
- Office Version
- 365
- 2021
- Platform
- Windows
- Web
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)
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
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