Conditionally updating cell values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If C2 > B2, I want to change B2 to C2, if not, I want to leave B2 unchanged.
I cannot figure out how to do this, can anyone offer advice?
 
Hi!

You can do this but it requires an intentional circular
reference! Use at your own risk!

Goto Tools>Options>Calculation. Check Iteration and set to
1.

In B2 enter this formula: =MAX(C2,B2)

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying formulas across columns 2
Difference Between Dates WITH Conditional Formatting 2
countifs Function not giving desired result with date criteria 2
Sumproduct in matrix means 3
Conditional sum, when condition has multiple values 3
Formula for elapsed time 3
Think I need a MAX / MIN formula here (help needed) 4
Multiple Functions of a Cell 3

Back
Top