are the values in A2, B2, C2 and D2 entered manually?
If so, you can not change them with a formula. You will need VBA to do that.
Are you open to a VBA solution?
It would help immensely if you could post a sample Excel file with some data that reflects your needs. Click "Go Advanced" below and then the paper clip icon to attach a file.
Bookmarks