Circular Error

[if_Excel]

i haVE a date / time calculation in cell F5: =TEXT(C3+0.33333, "dd mmm yyyy hh:mm") and cell C3 has a formula: =IF(AND(H2>8,H2<16),F3,IF(AND(H2>16,H2<24),F4,F5)). it calculates correctly when the formula evaluates to F3 and F4 but returns a circular reference when it evaluates to F5. this is because C3 depends on F5. Before turning ON iteration is there a way i could reconstruct this to avoid circular reference issue? thanks

 

[GlennUK]

You have circular logic ... you need to decide on some non-circular logic to reconstruct this.

 

[if_Excel]

thanks i solved it