I have four columns of data (A, B, C, and D). A and B have numbers in them and the cells in C are blank (to be filled in later on). I want column D to be the maximum value of either A or B if there is no number in column C. If a value is entered into column C, I want each corresponding cell in D to equal the values in C. Any suggestions on how to make this formula work??
Bookmarks