Combine Formula

[Johnboy28]

Hi,

Is it possible to combine the below into one formula?

If Room 1 - Receival & Room 2 - Receival equal 0 Return "In Transit"
If cell equals Receival 1 & Entry 1 Return "Processed" & If cell equals Receival 2 & Entry 2 Return "Processed"

Room 1 - Receival	Room 1 - Entry	Room 2 - Receival	Room 2 - Entry	Location
0	0	0	0	???
Receival 1	Entry 1	0	0
0	Entry 1	0	0
0	Entry 1	Receival 2	Entry 2
0	0	0	0
Receival 1	Entry 1	Receival 2	Entry 2
Receival 1	Entry 1	0	0
Receival 1	Entry 1	Receival 2	Entry 2
0	0	0	0

 

[awoohaw]

My pleasure!

Best Wishes!

 

[Johnboy28]

I just picked up - If receival 2 & entry 2 will equal "Processed" Are you able to amend?

Room 1 - Receival	Room 1 - Entry	Room 2 - Receival	Room 2 - Entry	Location
0	0	0	0	In Transit	Good
Receival 1	Entry 1	0	0	Processed	Good
0	Entry 1	0	0	In Transit	Good
0	Entry 1	Receival 2	Entry 2	In Chiller	Processed
0	0	0	0	In Transit	Good
Receival 1	Entry 1	Receival 2	Entry 2	Processed	Good
Receival 1	Entry 1	0	0	Processed	Good

 

[awoohaw]

There is a typo in the 3rd IF in the formula, my apologies. I have "Retreival" when it should be "Receival" if you edit that in the formula cell in row 2 and copy down you should be good to go.

Best Wishes!

 

[Johnboy28]

There is a typo in the 3rd IF in the formula, my apologies. I have "Retreival" when it should be "Receival" if you edit that in the formula cell in row 2 and copy down you should be good to go.

Best Wishes!

Great - Thank you. All sorted.