Multiple IF/IFERROR nested formulas

[RayZor123]

Hi All,

First time here after getting lots of help over the years, but unfortunately I've gone a bit rusty with my multiple IF formulas.

I need to write a formula to correct some error values in the source data but I cannot get this right. I've made my attempt in the "Manually Corrected Date" column. In the next column I've written the result I need to get. I have 900 lines to correct so hopefully there is an expert out there that can help me.....THANKS

 

[Joe4]

Welcome to the Board!

Since there are obvious errors in the formulas, we cannot really tell the rules/order you want to apply in each case.
Can you list the conditions, in plain English, of each situation. And remember, order does matter!

 

[Alex Blakenburg]

There are probably better ways to do this but this should work.
It assumes that if both are #Value to also use Manual.

Book1
	H	I	J
1	Log In	Log Out	Formula
2	1/09/2021	#DIV/0!	1/09/2021
3	#DIV/0!	1/09/2021	1/09/2021
4	1/09/2021	1/09/2021	1/09/2021
5	31/08/2021	1/09/2021	Manual
6	#DIV/0!	#DIV/0!	Manual
Sheet1

Cell Formulas
Range	Formula
J2:J6	J2	=IFERROR(IF(H2=I2,H2,"Manual"), IF(AND(ISERROR(H2),ISERROR(I2)),"Manual", IF(ISERROR(H2),I2,H2)))

 

[Joe4]

Ah, I did not realize that were supposed to examples of the same situation.
I thought you were looking for three different formulas.

 

[RayZor123]

Thanks.

So, I'm looking for one formula that fixes this, based on the following order:

1. If H&I equal same value, return row H
2. If column H has an error, return column I
3. If column I has an error, return column H
4: If column H&I do not equal same value (eg. multiple days in between each), return "Manual".

4 could go in under item 1 but I don't think it matters.

Apologies, I just saw that my screen-snip left out the row numbers.

Hopefully that is a clearer explanation. Thanks, if you can help!!

 

[Joe4]

My solution returns the same results as Alex's, so take your pick:

=IF(AND(ISERROR(H2),ISERROR(I2)),"Manual",IF(ISERROR(H2),I2,IF(ISERROR(I2),H2,IF(H2=I2,H2,"Manual"))))

 

[RayZor123]

Those formulas worked for me!!

Thanks for your help and quick replies!!

 

[Joe4]

You are welcome.
Glad we were able to help!