Circular reference problem

[krishnamohan]

Dear All,

I need to update a column based on the othet columns.

Ex: A B C D E
1 3 4 4 7

Here I need to update column D to E. If D<E(4<7 ) then D should become 7.
I tried but its giving circular reference problem.

Thanks in advance.

[meyero90]

I am not sure if I understand but the solution is highlighted in orange in the attached spreadsheet.
otherwise in cell D2 plug this

=IF(D1<E1,E1,D1)

assuming you data is in D1.

If I'm wrong, could you please attach a spreadsheet to get a better idea