How can I replace a cell value(numbers), if it is less than another cell value that contains numbers?
Can I have a formula?
Imagine 3 cells A1, B1 and C1 contains the value A1= nothing, B1=23.56 C1=78.42
If I enter 12.36 in A1 then the value of B1 should be replaced with A1 as A1 is less than the value in B1
If I enter 98.34 in A1 then the value of C1 should be replaced with A1 as A1 is greater than the value in C1
Hope my question is clear now?
How can I do the above function automatically using formula or any other method
Bookmarks