I have two columns in excel 2007. The columns are (price) and (MSRP). If B2 (MSRP) is greater then A2 (price) I want to replace B2 with A2.
A2: $238.80 B2:$299.99
Result: A2 $299.99
What formula would I use? I think its important to note: if greater than or equal to replace. If not leave cell alone.