Ignore blank cells

[soul1974]

Morning,
I keep getting recess front in my blank celss . How do i get the formula to ignore blank cells?
=IF($E2>$F2;$L2-$G2+5;IF($E2<F2;"Recess Front";"Correct"))

 

[gordsky]

the circular reference is in your origional code. It is because in your code you have a circular reference to column "M". (see your most recent screenshot)

You are pasting my code into column "M" but in the code you have the line "M2-H2+5". (because you omitted column A from your worksheet post)
In your original code that line was "L2-G2+5"

If you had inserted your code into the code I gave in post #5 the columns wouldnt have changed

Assuming the origional code you posted was correct it should be this

IF(E2="","",IF($E2>$F2;$L2-$G2+5;IF($E2<F2;"Recess Front";"Correct")))

 

[soul1974]

the circular reference is in your origional code. It is because in your code you have a circular reference to column "M". (see your most recent screenshot)

You are pasting my code into column "M" but in the code you have the line "M2-H2+5". (because you omitted column A from your worksheet post)
In your original code that line was "L2-G2+5"

If you had inserted your code into the code I gave in post #5 the columns wouldnt have changed

Assuming the origional code you posted was correct it should be this

IF(E2="","",IF($E2>$F2;$L2-$G2+5;IF($E2<F2;"Recess Front";"Correct")))

My Appologies,
I see now what I did.

Thank You for the assistance that worked.
You are awesome...

 

[gordsky]

My Appologies,
I see now what I did.

Thank You for the assistance that worked.
You are awesome...

glad i could help